Name
locate — returns the starting position of the first occurrence of an substring in a string
Synopsis
integer
locate
(
|
in string_exp1 varchar , |
| in string_exp2 varchar , | |
in
start
integer
); |
Description
Returns the starting position of the first occurrence of string_exp1 within string_exp2. The search for the first occurrence of string_exp1 begins with the first character position in string_exp2 unless the optional argument, start, is specified. If start is specified, the search begins with the character position indicated by the value of start. The first character position in string_exp2 is indicated by the value 1. If string_exp1 is not found within string_exp2, the value 0 is returned.