MySQL distinct random selection
View Single Post
I have two tables
I want to randomly select 10 rows from
which do not appear in
I can do random selection from one table using:
SELECT * FROM tbl1 ORDER BY rand() LIMIT 10;
Please assist on this.