FIND_IN_SET(pattern, strlist)

Returns the index position where the given pattern occurs in a string list. The first argument is the pattern you want to search for. The second argument is a string containing comma-separated variables. If the second argument is of the `SET`

data-type, the function is optimized to use bit arithmetic.

If the pattern does not occur in the string list or if the string list is an empty string, the function returns `0`

. If either argument is `NULL`

, the function returns `NULL`

. The function does not return the correct result if the pattern contains a comma ("`,`

") character.

SELECT FIND_IN_SET('b','a,b,c,d') AS "Found Results"; +---------------+ | Found Results | +---------------+ | 2 | +---------------+

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB

Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.

https://mariadb.com/kb/en/find_in_set/