Random sorting
Posted: Sun Jan 18, 2004 10:46 pm
Been searching forever (google, mysql.com, etc etc), and my question is so easy I can't believe I haven't found it yet..
I want to pick a random list of values from my table, so, is there any sql like this:
"SELECT * FROM `table` ORDER BY rand";
i believe thats what it was, im just not sure.. so is there a "random" order by clause?
thanks.
I want to pick a random list of values from my table, so, is there any sql like this:
"SELECT * FROM `table` ORDER BY rand";
i believe thats what it was, im just not sure.. so is there a "random" order by clause?
thanks.