Here is the mysql query I'm using to see which rows in our "tags" table have no matching row in our "taginfo" table.
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!