Answers for "select a random item from database"

SQL order random

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

Posted by: Guest on May-30-2020

select random sql

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1

Posted by: Guest on January-11-2021

Code answers related to "select a random item from database"