Random row grabs in MySQL

admin

Administrator
Staff member
Hey there, I'm trying to do something like the following...

SELECT * FROM Content WHERE CategoryID='$Cat' LIMIT 10

However, I'm trying to grab 10 random rows from the db, not the first 10 it finds everytime. Any magical command to help this along?

Regards,

-- npoole
 
Back
Top