select random sql
snippet in sql

SQL order random

user7967

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

select random sql

user9413

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1