I have this query:
SELECT link_id FROM linkindex WHERE word_id IN (102,103,107,46,45,469,68,27,104,260)
This runs on a relationship table which has link_id and word_id columns. The PRIMARY is (word_id, link_id) so links can be repeated multiple times for different word ids and word_id repeated multiple for different links (I think this is called many-many!)
The query above is matching in an OR way - so gives me link_ids with 102 OR 103 OR 107 etc...
How would I accomplish this in the AND method so the link_id must have 102 AND 103 associated with it to be returned?
As always, big thanks!