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
Post a Comment