FIND_IN_SET Function in SQL

The FIND_IN_SET function of Structured Query Language shows the position of the searched string in the multiple strings.

Syntax of FIND_IN_SET String Function

Syntax1: This syntax uses the FIND_IN_SET function with two or more column names of the SQL table:

In Find_In_Set syntax, we have to specify the name of those columns in which we want to search a string.

Syntax2: This syntax uses the FIND_IN_SET function with the string:

Syntax3: This syntax uses the FIND_IN_SET function with the individual character:

Examples of FIND_IN_SET String function

Example 1: The below query shows the position of the 'S' character in the given list of characters:

Output:

Example 2: The below statement shows the position of the 'u' character in the Congratulations string:

SELECT FIND_IN_SET( 'u', ''C, o, n, g, r, a, t, u, l, a, t, i, o, n, s '') AS Wishes u_Findinset;

Output:

Example 3: The following SELECT query finds the position of the 'New' string in the list of strings:

Output:

Example 4: This example uses the FIND_IN_SET function with the table in Structured Query Language.

In this example, we have to create a new SQL table through which we will execute the FIND_IN_SET() function on columns.

The syntax for creating the new table in the SQL database is as follows:

The following CREATE statement creates the Student_Grade table:

The below INSERT queries insert the records of students with grades and marks in the Student_Grade table:

The following SELECT statement displays the inserted records of the above Student_Grade table:

Query 1: The following SELECT query uses the FIND_IN_SET function with the First_City, Second_City, New_City columns of the above Student_Grade table:

This SQL statement shows the position of Ghaziabad city in the given three columns of the table.

Output:

Query 2: The following SELECT query uses the FIND_IN_SET function with the Hindi_Marks and Maths_Marks column of those Students whose Roll_No is greater than 2 in the above Student_Grade table:

Output: