searching data mysql
I have a table that has 3 fields.
Auto increment; video_id ; tag_id.
So for example:
1,1,4 2,1,3 3,2,2 4,3,1 5,3,4 6,3,3
If I wanted vids with tags 4 and 3 I'd have vid 1 and 3 returned. What would be the most efficient way of doing this ? IN() would work for OR but I want AND.
Submitted June 19, 2017 at 05:44AM by leaveatrace
via reddit http://ift.tt/2srfuAP