find_in_set
This function is used to return the position (stating from 1) of str1 in str2 separated by commas (,).
Syntax
find_in_set(string <str1>, string <str2>)
Parameters
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
str1 |
Yes |
STRING |
String to be searched for |
str2 |
Yes |
STRING |
String separated by a comma (,) |
Return Values
The return value is of the BIGINT type.
![](https://support.huaweicloud.com/intl/en-us/sqlreference-dli/public_sys-resources/note_3.0-en-us.png)
- If str1 cannot be matched in str2 or str1 contains commas (,), 0 is returned.
- If the value of str1 or str2 is NULL, NULL is returned.
Example Code
- Search for the position of string ab in string abc,123,ab,c. An example command is as follows:
The value 3 is returned.
select find_in_set('ab', 'abc,123,ab,c');
- Search for the position of string hi in string abc,123,ab,c. An example command is as follows:
The value 0 is returned.
select find_in_set('hi', 'abc,123,ab,c');
- The value of any input parameter is NULL. An example command is as follows:
The value NULL is returned.
select find_in_set(null, 'abc,123,ab,c');
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot