mysql - sql to match number in string -


I have a table in which one of the feeds has a comma-linked list of ids (I do not work) I know Would I like to match any number in this string? The problem is that I do not want to get the same numbers. Is there any way to match any number, which does not have any numerical chart on both sides?

  Table from SELECT *, where activities like 6 | Activities | --- + --------------- + --- | 3,16,8,6 --- + --------------- + --- | 6 | --- + --------------- + --- | 7,560 --- + --------------- + ---    

but you can try to do something like this:

  SELECT * from the table where the activities for REGEXP '[[:: :: & lt ;:] ] [0-9] + [[: & gt;:]] ';    

Comments