searching certain field start with...

[Anon]

hi guys, i have a database which hold user's surname, i would like perform a search for any surname start with "A", and list it out. can someone help??

thanks

[Anon]

and if the search didn't find anything, it should return a message as well. thanks

[[deleted]]

Doesn't anybody read any docs before they post?

SELECT *
FROM table
WHERE name LIKE 'A%';

the rest is just too elementary to post here.

[Anon]

thanks vincent, i've figured out that question myself, now, i have another question, i want the search to fullfill another argument, the search only list surname from category=male only.

i have tried the following code, but it doesn't work properly.

$searchfor='A';

"SELECT Singer, FirstName, LastName, Category FROM album WHERE category='male', LastName LIKE '$searchfor%' ";

please advise, thanks

[Anon]

i think i found the answer already, by using the 'AND' terms and it works fine.

[amcgrath]

Again, read the docs, dude... the answer is lose the comma after 'male'... you're in a WHERE statement... use AND LasName.....

[Anon]

what if i need to search for surname from A-D , anyone??

[[deleted]]

Keep reading the docs, it's all in there.