How to take a random record from a table, but so that the record ID of this record does not occur in another table?

Question

PHP

How to take a random record from a table, but so that the record ID of this record does not occur in another table?

Answer 1

SELECT * FROM `table1` WHERE `id` NOT IN(
    SELECT `id` FROM `table2`
) ORDER BY RAND() LIMIT 1