Skip to content
v1.30.6
Install

FIND_IN_SET

FIND_IN_SET(str,strlist)

Section titled “FIND_IN_SET(str,strlist)”
  • str: This parameter represents the string to be found. It is the value that will be searched within the set provided in the strlist parameter.
  • strlist: This parameter represents the string list within which the search will be performed. It should be a list of substrings separated by commas, wherein the str parameter will be searched.

Example

Section titled “Example”
SELECT FIND_IN_SET('b', 'a,b,c,d');

Output

Section titled “Output”
2

Explanation

Section titled “Explanation”

The FIND_IN_SET function in MySQL is used to search for the position of a string within a list of strings separated by comma. The output ‘2’ denotes that ‘b’ is the second string in the set ‘a,b,c,d’.