locate(source text, target text, start_index)

Let us now check the locate(string,source text, target text, start_index) function with the following query.

Query

default> select locate('tutorialspoint','point',10) as string_position;

Result

The above query will generate the following result.

string_position 
------------------------------- 
10

The output returns the location of the specified string “point” from the given input string “tutorialspoint”. The position is 10.