string contains regex , like ?

string:
',12,13,14,15,'

how to figure out that it contains 13 and 15 ?

You can go with either one.

SELECT * FROM table WHERE string LIKE '%13%

or

SELECT * FROM table WHERE string REGEXP '.*13.*'

how to figure out that it contains 13 and 15 ?


The 13 is easy. But 13 and 15 ?
Besides '%...%' is very slow, barely usable, that is, not usable at all, at least on MySql.

Oh, both...

Then just do AND string REGEXP '.*15.*'

As for using LIKE, I know its slower then other things, but barely if not useable in mySQL? I've been using it for a while with no notable issues.