How can I take a random row out of a MySQL table? I don't think there are any SQL command for it.
A code snippet is VERY appreciated.
Thanks.
in mysql 3.23+:
select * from your_table order by rand() limit 1;
But how can I do it if I only have version 3.22+?
And please don't reply upgrade, 'cause it's not my server 🙂
Search the forum, this has been done already by other people.
