POSITION()
function returns the position of the first occurrence of a substring in a string. It works the same as
STRPOS, but it has slightly different syntax.
world
within the string Hello, world!
.
world
, which is 7.
123
within the string 1a2b3c
.
123
is found starting at position 1, the result would be 1.
abc
within the string xyz
.
abc
is not found in xyz
, the result would be 0.
cde
within the string cde
.
cde
is the entire string, the result would be 1.