Matching all values in IN clause

by

You can do something like this:

select ItemID
from ItemCategory
where CategoryID in (5,6,7,8) <-- de-dupe these before building IN clause
group by ItemID
having count(distinct CategoryID) = 4 <--this is the count of unique items in IN clause above

If you provide your schema and some sample data, I can provide a more relevant answer.

SQL Fiddle Example

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. SQL split values to multiple rows
  3. Get records with max value for each group of grouped SQL results
  4. How to populate a table with a range of dates?
  5. MYSQL OR vs IN performance
  6. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  7. MySQL Cannot Add Foreign Key Constraint
  8. Grouping into interval of 5 minutes within a time range
  9. How to find gaps in sequential numbering in mysql?
  10. Convert timestamp to date in MySQL query
  11. Update a column value, replacing part of a string
  12. MySQL: View with Subquery in the FROM Clause Limitation
  13. MySQL/MariaDB – order by inside subquery
  14. View’s SELECT contains a subquery in the FROM clause
  15. Can MySQL replace multiple characters?
  16. OUTPUT Clause in MySQL
  17. Using ORDER BY and GROUP BY together
  18. Sorting by date & time in descending order?
  19. Difference between these two joining table approaches?
  20. MySQL Pivot Table Column Data as Rows
  21. updating columns with a sequence number mysql
  22. MySQL, Concatenate two columns
  23. Select a column with a keyword name
  24. MySQL Stored Procedures not working with SELECT (basic question)
  25. ERROR 1148: The used command is not allowed with this MySQL version
  26. Use Composite Primary Key as Foreign Key
  27. MySQL Select minimum/maximum among two (or more) given values
  28. How to select data where a field has a min value in MySQL?
  29. Update multiple rows with multiple ‘where’ clauses for each individual row
  30. ORDER BY alphabet first then follow by number

Leave a Comment