arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

startswith

This section contains reference documentation for the STARTSWITH function.

returns true if columns starts with prefix string.

hashtag
Signature

STARTSWITH(col, prefix)

hashtag
Usage Examples

value
value
SELECT STARTSWITH('Apache Pinot', 'Apache') AS value
FROM ignoreMe

true

SELECT STARTSWITH('Apache Pinot', 'Pinot') AS value
FROM ignoreMe

false