Apache Presto - index(string,substring)



Query

presto:default> select index('tutorialspoint','point') as index; 

Result

 index 
------- 
  10

Here, the index position 10 for the given string ‘tutorialspoint’ is point.

apache_presto_sql_functions.htm
Advertisements