mysql search query issue like query

Question

My column value like this. I want to search the value 1 from the given column.

SELECT * FROM `tbl_test` WHERE `userServices` LIKE '%1%' LIMIT 0 , 30

But the above query gives me two values row 2 and 3

%LIKE% sentence search all posibilities for 1, like 1,2 or 11. If you want just 1 use **=**, userServices = 1 — Roy Bogado, Jul 25 '18 at 09:02
But my column values are like this 1,2 in each row. And = , LIKE,IN not working — ankush deshmukh, Jul 25 '18 at 09:05
I can't understand what you need. All values that start with 1?, give examples — Roy Bogado, Jul 25 '18 at 09:07

score 2 · Accepted Answer · answered Jul 25 '18 at 09:06

2

Use FIND_IN_SET.

The below query should work for you.

SELECT * FROM `tbl_test` WHERE find_in_set('1', `userServices`) <> 0;

answered Jul 25 '18 at 09:06

skelwa

1 Answers1