MySQL 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')