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.