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.