In MySQL, I have a table of products connected with a different table with categories.
I often show the list by making a LEFT JOIN and GROUPING the results:
e.g. LEFT JOIN gives me:
Name | Category
Cool cap | clothes
Cool cap | hats
Then GROUPING by ID gives me 1 result.
The question: How can I show a list of products with
category='clothes' AND category='hats'? Because the item won't show up because each category shows on a new line.