Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT id
- FROM tbl
- WHERE col1 IN ('00020', '00023')
- GROUP BY id
- HAVING GROUP_CONCAT(DISTINCT col1 ORDER BY col1) = '00020,00023';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement