MySQL delete records in one table that do not exist in another table

April 19, 2020

This post brought to you by RocketGeek, ButlerBlog, and the following:

DELETE FROM content_to_tags
WHERE NOT EXISTS (
    SELECT *
    FROM content
    WHERE content_id = content_to_tags.content_id
)