Last First
New member
This should be easy enough to understand. I have a CSV value in MYSQL ex: "chicken,penguin".
I need to find which row contains chicken AND penguin. I've been using find_in_set('chicken', items)
But if I do find in set with chicken AND chicken it would still return true for "chicken,penguin"
What do? To make sure both of the items are correct?
I need to find which row contains chicken AND penguin. I've been using find_in_set('chicken', items)
But if I do find in set with chicken AND chicken it would still return true for "chicken,penguin"
What do? To make sure both of the items are correct?