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 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.