Search results

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...

So yeah I need to store an array in MYSQL, something like array(3, 1, 5); but I also want to be able to use the MYSQL SELECT to select a row that contains 1 AND 5 for example. So should I save the array as a CSV using php implode? If I do that how would I do a select where the array contains 1...