Apache Pinot Docs
latest
Search
⌃K

startswith

This section contains reference documentation for the STARTSWITH function.
returns true if columns starts with prefix string.

Signature

STARTSWITH(col, prefix)

Usage Examples

SELECT STARTSWITH('Apache Pinot', 'Apache') AS value
FROM ignoreMe
value
true
SELECT STARTSWITH('Apache Pinot', 'Pinot') AS value
FROM ignoreMe
value
false
Previous
sqrt
Next
ST_AsBinary
Last modified 1yr ago