Is it possible that select records for example 20 records from the table randomly, but in addition 1 certain record for example 3rd record.
Let me explain:
SELECT * from table limit 1, 20 rand();
In this way I will get 20 randomly records but I want that one certain record should must contain in these records, lets suppose id = 3 should also contain in these 20 records.
How can i retrieve this with a single query?