Let`s say we have an Articles table and a Tags table. Articles are Many to Many with Tags with a ArticlesTags table.
How can i come up with a find that gets me All the Articles that have many of the same tags.
(Ex. I want all the articles that have both the tag with name “Cake” and the tag “PHP”).
I am trying with matching but i can only get ALL the Articles connected with either “Cake” or “PHP”.
- if i add an “AND” or chain the matching for both tags i get an SQL like …tag_name=“Cake” and tag_name=“PHP”… wich returns 0 rows :).