Choosing a random result from MySQL

Question

I wanted to randomly select the results from the mysql database using this code:

$data = mysql_query("SELECT * FROM people ORDER BY RANDOM() LIMIT 4") or die(mysql_error()); 

I got an error message: Members FUNCTION.RANDOM does not exist

Is there something that I am not adding or doing right here?

Thank you for your attention.

Answer 1

The name of the function you are looking for is RAND () .

Answer 2

You need ORDER BY RAND()

 $data = mysql_query("SELECT * FROM people ORDER BY RAND() LIMIT 4") or die(mysql_error()); 

Answer 3

MySQL uses RAND () instead of RANDOM ().

Answer 4

Since this is MySQL, you need to use RAND () instead of RANDOM ().

Answer 5

This is a very good source of recommendations for efficiently extracting random records from a table with MySQL.

http://www.dasprids.de/blog/2008/06/07/fetching-random-rows-of-mysql-efficiently

You can check it out.