Apache Presto - strpos(string,substring)


Query 1

presto:default> select strpos('apache','ap') as string_position; 

Result

 string_position 
----------------- 
       1

Query 2

presto:default> select strpos('apache','c') as string_position; 

Result

 string_position 
----------------- 
       4
apache_presto_sql_functions.htm
Advertisements