starts_with(`source_str`, `search_str`)

Returns a Boolean indicating whether a string begins with the search string.

STARTS_WITH() follows this syntax.

Example

This example returns a Boolean that confirms whether the value in the City field begins with “Hen.”

1SELECT City, STARTS_WITH(City, "Hen") as "startValue"
2FROM "Superstore"
3LIMIT 5;