Table with Tags associations So I have a table with tags and the videos they belong to. Both columns are primary. 


..and so on

I need to make a list of the videos that have certain tags (multiple) associated with them.

So if I need all videos that have both tags 123 and 124, it would give me videos 14962 and 14963, etc.

I made the table structure assuming this would be easy, but have been staring at this for an hour and I'm still not seeing it.
SELECT group_concat(tag) AS tags
  FROM table
 WHERE tag IN (123,124,234)
 GROUP BY video 
 ORDER BY video
;