LOCATE() – MySQL Function

LOCATE() – MySQL Function

The LOCATE() function returns the position of the first occurrence of a substring in a string.

If the substring is not found within the original string, this function returns 0.

This function performs a case-insensitive search.

LOCATE(substring, string, start)

Parameter Description
substring Required. The substring to search for in string
string Required. The string that will be searched
start Optional. The starting position for the search. Position 1 is default
Exapmple of Locate function:

SELECT LOCATE(“u”, “eduguru.in”) AS showPosition;

showPosition
3

SELECT LOCATE(“u”, “eduguru.in”, 4) AS showPosition;

showPosition
5