MySQL FIND_IN_SET() Function
Example
Search for "q" within the list of strings:
SELECT FIND_IN_SET("q", "s,q,l");
Try it Yourself »
Definition and Usage
The FIND_IN_SET() function returns the position of a string within a list of strings.
Syntax
FIND_IN_SET(string, string_list)
Parameter Values
| Parameter | Description |
|---|---|
| string | Required. The string to search for |
| string_list | Required. The list of string values to be searched (separated by commas) |
Return Values
- If string is not found in string_list, this function returns 0
- If string or string_list is NULL, this function returns NULL
- If string_list is an empty string (""), this function returns 0
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Search for "a" within the list of strings:
SELECT FIND_IN_SET("a", "s,q,l");
Try it Yourself »
Example
Search for "q" within the list of strings (string list is NULL):
SELECT FIND_IN_SET("q", null);
Try it Yourself »
Copyright 1999-2023 by Refsnes Data. All Rights Reserved.