how to find all data separated by comma in mysql
SELECT * FROM `ss_services` WHERE find_in_set(4,`outlets`)<>0
get data when you have multiple values in one column
Like that
![]() |
id | service_name | service_price | outlets | ||
---|---|---|---|---|---|---|
![]() |
![]() |
6 | service1 | 500.00 | 4 | |
![]() |
![]() |
7 | service2 | 400.00 | 1 | |
![]() |
![]() |
10 | shubh test | 27.00 | 1,4 | |
![]() |
![]() |
11 | hail cutting and saving | 100.00 | 4 |