MySQL Check List and Check String & Forms

[KGodel]

Originally Posted by Dave

You can use LIKE in a WHERE statement like:

PHP Code:

WHERE favorites LIKE '23,%' OR favorites LIKE '%,23,%' OR favorites LIKE '%,23' 


There might be an easier way to do this, but not aware of that at the moment.

Can I only use one LIKE and group the ORs in parens just like you would for WHERE?

Originally Posted by Scanu

Then you need the second one, i couldn't think of an easier way to do it right now

If the list only has 1 number and I use explode with the comma, will it still create an array with 1 value?