STARTSWITH

This page describes the STARTSWITH function in Lenses SQL.

STARTSWITH(exprSource, exprTarget)

Returns true if an expression starts with the given substring.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

USE `kafka`;
SELECT 
    STARTSWITH(email, 'Jo'), 
    email 
FROM users-topic
LIMIT 3;

Output:

{
  "value": {
    "STARTSWITH": true,
    "email": "[e-mail]"
  }
}
{
  "value": {
    "STARTSWITH": true,
    "email": "[e-mail]"
  }
}
{
  "value": {
    "STARTSWITH": false,
    "email": "[e-mail]"
  }
}