simple question and solution about a query string

[bossman]

hello all, haven't been in here in a while, took a break from developing but now im back at it and a bit rusty :/

 

i'm trying to write a query so that when a user clicks a link that says "A" , it will grab all the names in the database that start with an "A".  I wanna do the same thing with the whole alphabet.  Anyone have any suggestions on a query?

 

something like "Select id, name, contact_name, street_address, city, state, zipcode, country, phone_number, email, website FROM hair_loss_clients ORDER BY name ASC ----- ??? "  what would go at the end there to make it select only titles that start with "A"?

 

THANK YOU IN ADVANCE!

[Alex]

Select id, name, contact_name, street_address, city, state, zipcode, country, phone_number, email, website FROM hair_loss_clients WHERE name LIKE 'A%' ORDER BY name ASC

[bossman]

thank you very much!!!! that helped alot!