Select random rows from a database base with MySQL
The following query would return 1 random row from the data table:
SELECT * FROM `data` ORDER BY RAND() LIMIT 0,1;
Code language: JavaScript (javascript)
Select random rows from a database base with MySQL
The following query would return 1 random row from the data table:
SELECT * FROM `data` ORDER BY RAND() LIMIT 0,1;
Code language: JavaScript (javascript)