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 are the differences between GROUP BY and ORDER BY...the manual is not clear on this

GROUP BY is a way to sub-total your results, or perform some other "aggregate" function on...

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

Useful Tutorials:Examples on using MySQL commands:...

Does mysql support foreign keys ?

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

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're trying to access $result...

How do I delete a table from a database?

Use this sql command "DROP TABLE yourtablename"