Forum Moderators: open

Message Too Old, No Replies

mysql Filter by letters

letters mysql

         

riquelme

1:47 pm on Apr 26, 2007 (gmt 0)

10+ Year Member



Greetings!

I'm doing a list of singers and I now need to allow our visitors to chose a letter, and show them only singers whose names begin with the chosen letter.

I head there was a mysql function to do that directly from the query. Could anyone enlighten me please?

Thanks!
Regards

coopster

2:00 am on Apr 27, 2007 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Welcome to WebmasterWorld, riquelme.

You could always grab the first letter using SUBSTRING.