Apache-presto-string-function-strpos
提供:Dev Guides
Apache Presto-strpos(string、substring)
クエリ1
presto:default> select strpos('apache','ap') as string_position;
結果
string_position
-----------------
1
クエリ2
presto:default> select strpos('apache','c') as string_position;
結果
string_position
-----------------
4