1 of 1

ENDSWITH

This page describes the ENDSWITH function in Lenses SQL.

ENDSWITH(sourceExpr, targetExpr)

Returns true if an expression ends with the given substring.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    ENDSWITH(status, 'unverified'), 
    status 
FROM users-topic
LIMIT 2;

Output:

{
  "value": {
    "ENDSWITH": false,
    "status": "verified"
  }
}
{
  "value": {
    "ENDSWITH": true,
    "status": "unverified"
  }
}

This page describes the ENDSWITH function in Lenses SQL.

ENDSWITH(sourceExpr, targetExpr)

Returns true if an expression ends with the given substring.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    ENDSWITH(status, 'unverified'), 
    status 
FROM users-topic
LIMIT 2;

Output:

{
  "value": {
    "ENDSWITH": false,
    "status": "verified"
  }
}
{
  "value": {
    "ENDSWITH": true,
    "status": "unverified"
  }
}