Javatpoint Logo
Javatpoint Logo

MySQL LOCATE() Function

LOCATE(substr,str) is a Sring function of MySQL. This method returns the first occurrence of given substr in the given string,

Syntax

Example 1

Output:


MySQL String LOCATE() Function

Example 2

Output:


MySQL String LOCATE() Function
Next TopicMySQL String




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA