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

Related posts:

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... Read More about Chandra Shekhar

Latest posts by Chandra Shekhar (see all)