2 order by clauses -> possible?

[mcshen]

hi
i have a table full of quotes.
i want to get 1 randomly and order by quote asc.

so, i tried this

select * from quotes order by rand() and quote asc ; -> it didn't work

select * from quotes order by rand() order by quote asc; -> it didnt work

please help me out here. thanks.

[cgraz]

if I remember correctly, the syntax is

SELECT * FROM table ORDER BY field1, field2

Cgraz