How can I select random rows from a table?

SELECT * FROM table_name ORDER BY RAND();

Found at http://www.mysql.com/doc/M/a/Mathematical_functions.html
    
use:

SELECT * FROM table_name ORDER BY RAND() limit 1;

If you only want one result not all of them.

Was this answer helpful?

 Print this Article

Also Read

What does this error message means - Warning: Supplied argument is not a valid MySQL result resource and how do you solve it?

I think you got this message from PHP. You get this message when you are trying to access...

How do I delete a table from a database?

Use this SQL command : "DROP TABLE yourtablename"

Select statement to join tables?

For a simple join: SELECT a.*, b.*FROM tblAlpha a, tblBeta bWHERE (a.keyfield = b.foreignkey);...

Does mysql support foreign keys?

The answer to this is two-fold. Yes. MySQL _DOES_ allow the creation of foreign key...

I'm new to MySQL, where should I start?

The best source of MySQL information is the excellent on-line manual : ...