List mysql results by#, or Letter start with?

[brandon0401]

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]

Can you modify your WHERE clause in the SQL query?

WHERE myfield LIKE 'A%'

String Comparison Functions [dev.mysql.com]