Organizational Research By

Surprising Reserch Topic

Experts Most Trusted 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
64 views



Related Hot Questions



Government Jobs Opening


...