How to check if a record is linked with two or more values in a left join
GROUP BY Name
HAVING COUNT(*) &gt;= 2


You may need to do something like this:

WHERE ...
  AND ( SELECT COUNT(*)
           FROM tbl
           WHERE Name = ...
           GROUP BY Name
           HAVING COUNT(*) &gt;= 2 )


For checking for exactly a certain list:

           WHERE Category IN ('clothes', 'hats')
           GROUP BY Name, Category
           HAVING COUNT(*) = 2


(There can't be more than 2 after the GROUP BY; this confirms that both are included.)

           WHERE Category IN ('clothes', 'hats', 'scarves')
           ...
           HAVING COUNT(*) &gt;= 2


would check for any 2 of those 3 (or all 3).