I have a table "masterurls" it has morethan 1 million records. I want to fetch random records each time the query executed. It should not have any of the records that were fetched in previous executions. I'm already have this query:
SELECT m.url FROM masterurls ORDER BY RAND() LIMIT 200
The problem is the above query returns only first 200 hundred records and randomizes it each time.
See Question&Answers more detail:os