[MySQL] FIND_IN_SET()

MySQL 문자열 함수와 연산자

 

FIND_IN_SET()

   - 

 

FIND_IN_SET(str, strlist)

의 형태

 

Returns a value in the range of 1 to N if the string str is in the string list strlist consisting of N substrings. A String list is a string composed of substrings separated by , characters. If the first argument is a constant string and the second is a column of type SET, the FIND_IN_SET() function is optimized to use bit arithmetic. Returns 0 if str is not in strlist or if strlist is the empty string. Returns NULL if either argument is NULL. This function does not work properly if the first argument contains a comma(,) character.

 

mysql> SELECT FIND_IN_SET('C' , 'A,B,B,C,D') ;
+--------------------------------+
| FIND_IN_SET('C' , 'A,B,B,C,D') |
+--------------------------------+
|                              4 |
+--------------------------------+
1 row in set (0.00 sec)