POSITION

The string function used to determine the position of a substring in a string

Parameter Type Description
str
string
the string to search
substring
string
the substring to search for
Returns: string

Example

query:

SELECT POSITION("y", "Amaryllis")

results:

position
5

The POSITIONfunction requires two arguments. The first argument is the substring whose position is to be determined. The second argument is the string to be searched.