Quick Question about like%

[TheMayhem]

$members = mysql_query("select * from user WHERE username LIKE '$letter%' ORDER BY username ASC LIMIT $membersdisplay,$membersnum");

Very easy query with $letter being from A-Z depending on the page. My question is for this what would I need to do for a query or to replace letter with so on one page it'd display the first character of a username being 0-9 and then another page displaying any odd characters such as ^,@,*, ect.?

[sarahk]

try using something like

where left(username,1) >= "0" and left(username,1) <= "9"

and there will be something similar you can do for the special chars.

Sarah