select random rows sql code example

Example 1: SQL order random

SELECT FIELD_NAME FROM TABLE_NAME ORDER BY RAND() LIMIT 1
/* NOTE if this doesnt work try random() */

Example 2: select random sql

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1

Example 3: sql pick random row

SELECT column FROM table
ORDER BY RAND()
LIMIT 1

Example 4: select random rows sql

Using a SAMPLE clause, we can select random rows.
SELECT * FROM table_name SAMPLE(10);