Here is the mysql query I'm using to see which rows in our "tags" table have no matching row in our "taginfo" table.

SELECT *
FROM `tags`
WHERE `snub` NOT
IN (

SELECT `snub`
FROM `taginfo`
)

Now, I want to take this query a step further. I'm hoping to select not only the rows in the "tags" table where the "snub" column has no match, but I want to select the rows that only occur once. For instance:

list of "snub" variables in the "tags" table

comedy
romance
actor name
actor name
romance
foreign

So, in this case, it would select rows with comedy and foreign as the snub, since they only appear once.

I can't figure out how to achieve this. (my final goal is to delete all rows that have single instance not matching).

All feedback appreciated!
Cheers
Ryan