Function Reference
LOCATE
Returns the position of the first occurrence of a substring in a string
MySQL 8.1
LOCATE(substr, str, [start_position])substr
Search substring
str
The string in which the substring is searched for
start_position
Optional. Search start position
If no matches are found, 0 is returned.
Examples
MySQL 8.1
SELECT LOCATE('world', 'Hello world')