Organizational Research By

Surprising Reserch Topic

mysql check if numbers are in a comma separated list


mysql check if numbers are in a comma separated list  using -'mysql,list'

I have a table like this:

UID(int) NUMBERS(blob)
----------------------
1        1,13,15,20
2        3,10,15,20
3        3,15


And I would like to test if 3 and 15 are in the blob called NUMBERS. And can see the LIKE %% cannot be used

Only row with ID 2 and three scoulb be selected...
    

asked Sep 22, 2015 by ajit.chavhan
0 votes
69 views



Related Hot Questions

4 Answers

0 votes
NULL
answered Sep 22, 2015 by deven.bendale
0 votes
NULL
answered Sep 22, 2015 by virendra.bajaj
0 votes
NULL
answered Sep 22, 2015 by deepak07.s
0 votes
NULL
answered Sep 22, 2015 by vijaygupta1980

...