David Fallon wrote:
> Is it possible to SELECT a random recordset out of a database? If so, what's
> the syntax? (I want to get a random selection of 5 items from a table).
> I'm not subscribed to the list, so please reply directly to me.
I've not tested this myself.
You have to use 3.23.3 for this to work (which I currently don't use):
SELECT * FROM table ORDER BY RND() LIMIT 5;
Or you can add a column and fill it randomly to sort after this (works with 3.22.xx
ALTER TABLE table ADD random DOUBLE;
UPDATE table SET random=RND();
SELECT * FROM table ORDER BY random LIMIT 5;