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.

Kickstart Your Career

Get certified by completing the course

Get Started