LOCATE

LOCATE(string,substring[,position[,occurrence]])

Returns the position of substring within string.

• If position is specified and positive, the search begins position characters into string
• If position is negative, the search begins position characters from the end of string
• If occurrence is specified, the occurrenceth occurrence of substring in string is located

If substring does not exist within string, 0 is returned.

See also the INSTR function.