STR_BEFORE

The string function for finding the portion of one string that occurs before 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_BEFORE("LONDON", "N")

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

results:

str_before
LO