INSTR

INSTR(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 LOCATE function.