Comma Separated search using fine_in_set function of MySql

find_in_set function is used to search comma separated values . For example if you are storing comma separated values of multiple choice like (1,3,5) then you can search it using find_in_set function.

Example of find_in_set
SELECT *
FROM table
WHERE FIND_IN_SET( ‘3’, service_offered )
LIMIT 0 , 30

Find_in_set function accept two argument
argument1: string to be found
argument2: table field_name from which we need to search string

The following two tabs change content below.

Chandra Shekhar

GCP Architect
Chandra Shekhar Pandey is Google certified Cloud engineer, I am Magento2 Trained developer. Having huge experience in designing cloud solution. I have around 12 years of experience with world enterprise IT companies and fortune 500 clients. During my architecture design I am always caring about high availability, fast performance and resilient system. From the programmer background I have huge experience in LAMP stack as well. Throughout my carrier I have worked on Retail, E-Learning, Video Conferencing and social media domain. The motive of creating cutehits was just to share the knowledge/solutions I get to know during my day to day life so that if possible I can help someone for same problems/solutions. CuteHits.com is a really a very effort for sharing knowledge to rest of the world. For any query/suggestion about same you can contact me on below details:- Email: shekharmca2005 at gmail.com Phone: +91-9560201363

Latest posts by Chandra Shekhar (see all)

You may also like...