Answers for "mysql get random row"

SQL
3

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
2

mysql select random id from table

-- randomly order, select first 5 rows
select * from `table_name` order by rand() limit 5
Posted by: Guest on November-07-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language