locate(source text, target text, start_index)
Advertisements
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.
apache_tajo_string_functions.htm
Advertisements