POSITION(x IN y)

This function returns the position of the first occurrence of a sub-string in a string. If the sub-string is not found within the original string, this function returns 0. This function performs a case-insensitive search.

Example:

Search for "y" in string "Pranalytix.com", and return position: POSITION("y" IN "Pranalytix.com") = 7.