
- Apache Presto - Home
- Apache Presto - Overview
- Apache Presto - Architecture
- Apache Presto - Installation
- Apache Presto - Configuration
- Apache Presto - Administration
- Apache Presto - SQL Operations
- Apache Presto - SQL Functions
- Apache Presto - MySQL Connector
- Apache Presto - JMX Connector
- Apache Presto - HIVE Connector
- Apache Presto - KAFKA Connector
- Apache Presto - JDBC Interface
- Custom Function Application
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