C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL FIND_IN_SET() FunctionFind_in_set(str,strlist) is a Sring function of MySQL. This method return the value of the string which is given in first position in argument. Syntax
select find_in_set(str, 'str1, str2,...'); Example 1
Select find_in_set('a','b,c,d,a');
Output:
Example 2
Select find_in_set(4,'1,2,3,5,4,6'); Output:
Example 3Select find_in_set(12,'1,2,3,4,6'); Output:
Next TopicMySQL String
|