MySQL question.
table tags (id, ...)
table video (id, ...)
table video2tags (videoid, tagsid, ...)
Given a number of tag id's, I am trying to select videos that are tagged with multiple tags.
SELECT video.id FROM video, video2tags WHERE (video.id = video2tags.videoid AND video2tags.tagsid = 89) AND (video.id = video2tags.videoid AND video2tags.tagsid = 88);
This doesn't seem to work. Any pointers would be really welcome!
# Feb 1, 2005