I was contemplating pulling a randomised dataset from the database for a module I am working on, but this does rely on some clever cross platform sql randomisation code. I know the following works on Postgres:
Code: Select all
SELECT * FROM table ORDER BY random()
Code: Select all
SELECT * FROM table ORDER BY rand()
Any ideas anyone?
Tom