Order by first letter

[Anon]

I want to pull all person which their first letter begin with J, what should I do

is this right ?

mysql_query("SELECT * FROM name ORDER by first='j',$db);

to get all person with first letter J

[brandonschnell]

SELECT col1, col2, col3 FROM name WHERE first LIKE 'j%' ORDER BY first

[nagasea]

okay that's works.
how if i want to order by number between 0-9