STR_AFTER

The string function for finding the portion of one string that occurs after it contains another string. If the first string does not contain the second, an empty string is returned.

Parameter	Type
`value`	string
`partition`	string

Returns: string

Example

query:

SELECT STR_AFTER("LONDON", "N")

siyeh/sql-crm-example-data Run query Copy code

results:

str_after
DON