I am new to writing sql queries in presto and was looking for a function similar to 'starts_with'. If a string starts with a given substring then the query needs to return that record. In Postgresql, I am currently doing select * from tableA where name~'^Joh'. Whats the equivalent of this in Presto?

CodePudding user response：

PostgreSQL and presto are RDBMS based on SQL. It is weird to see that you've learned a PostgreSQL proprietary add on (regular expressions) to the language before learning the standard SQL functions. In SQL you use LIKE for pattern matches:

select * from tableA where name like 'Joh%';

CodePudding user response：

You can use Like in SQL. You can go through this link https://www.w3schools.com/sql/sql_like.asp. Using like you can search for a specified pattern.