Forum Moderators: coopster

Message Too Old, No Replies

List mysql results by#, or Letter start with?

         

brandon0401

6:49 pm on Jul 9, 2008 (gmt 0)

10+ Year Member



Hey everyone, anyone know how, have a script handy or know of one out there that can list mysql results by # or Letter they start with?...IE:

#
List all mysql results in table that start with a #

A
List all mysql results in table that start with a A

B
List all mysql results in table that start with a B

.....

Z
List all mysql results in table that start with a Z

thanks in advance!
B

coopster

3:57 am on Jul 10, 2008 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Can you modify your WHERE clause in the SQL query?
WHERE myfield LIKE 'A%'

String Comparison Functions [dev.mysql.com]