Find Rows Without Match in 2nd Table, and Select Rows that Only Occur Once in 1st
Here is the mysql query I'm using to see which rows in our "tags" table have no matching row in our "taginfo" table.
WHERE `snub` NOT
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
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!