Select a random record.

You want to select a completely random record from a table.

The sub SELECT in this query retrieves your desired columns from the table foo, adding the RANDOM() function to generate a column containing a random number for each record. The results are placed into a new temporary table bar which is sorted by the value of the random column. We use ORDER BY 3, because the random column is the third one in the table. If we were only selecting cat, random (), we would use ORDER BY 2.



The table will look like the following:

Then a single result is returned using LIMIT 1.