Skip to content

FIND_IN_SET()

Function Description

  • str is the string to query
  • strList is the field name, and the parameters are separated by "," such as (1,2,6,8)
  • Query the result contained in the field (strList), returning the result NULL or record.

If the string str is in a string list strlist composed of N substrings, the return value ranges from 1 to N. A string list is composed of substrings separated by the , symbol. If the first parameter is a constant string and the second parameter is a column of type SET, the FIND_IN_SET()` function will be optimized to use bit operations. Returns 0 if str is not in strlist or strlist is an empty string. Returns NULL if either parameter is NULL. If the first parameter contains the comma (,) character, this function will not work properly.

Function Syntax

> FIND_IN_SET(str,strlist)

Parameter definition

Parameters Description
str Required parameters. Both CHAR and VARCHAR types are supported.
strlist Required parameters.

Example

select find_in_set('b','a,b,c,d');
+------------------------------+
| find_in_set(b, a,b,c,d) |
+------------------------------+
| 2 |
+------------------------------+