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

 

Full Texts id service_name service_price outlets
Edit Delete 6 service1 500.00 4
Edit Delete 7 service2 400.00 1
Edit Delete 10 shubh test 27.00 1,4
Edit Delete 11 hail cutting and saving 100.00 4

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *