LOGIN
Wednesday, April 24, 2024
Top Posts
SUBSCRIBE NEWSLETTERS
Home » MySQL String LOCATE() Function
MySQL String FunctionMysql Tutorial

MySQL String LOCATE() Function

by Online Tutorials Library

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

You may also like

MySQL String MID() Function

MySQL String OCTET_LENGTH() Function

MySQL String POSITION() Function

MySQL String LEFT() Function

MySQL String LENGTH() Function

MySQL String LCASE() Function