For my next project I need a sql query for mysql which retrieve random row. After some browsing, I found the sql query. Here it is:
SELECT * FROM table
ORDER BY RAND()
LIMIT 1
For my next project I need a sql query for mysql which retrieve random row. After some browsing, I found the sql query. Here it is:
SELECT * FROM table
ORDER BY RAND()
LIMIT 1