How is the find_in_set function used in SQL?

In SQL, the FIND_IN_SET() function is used to search for a value in a comma-separated string list and return its position. The syntax of this function is as follows:

FIND_IN_SET(search_value, comma_separated_list)

In this case, search_value is the value to search for and comma_separated_list is a list of strings separated by commas. If the search_value is found in the comma_separated_list, return its position (starting from 1), otherwise return 0. Here is an example:

SELECT FIND_IN_SET('apple', 'orange,apple,banana,mango'); 

The query above will return 2, as ‘apple’ is in the second position in the list of strings.