select value from a rondom row mysql 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: mysql select random id from table

-- randomly order, select first 5 rows
select * from `table_name` order by rand() limit 5