CodesJava

Easy learning with example program codes

POSITION() FUNCTION in MySQL

POSITION() FUNCTION
The MySQL POSITION function is used to get the location of a substring in a string. The various versions of MySQL supports the POSITION function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23.

Syntax:

POSITION( substring IN string )

Parameters:
substring: It is used to specify the substring to search for.
string: It is used to specify the string to search.

Example 1:

mysql> SELECT POSITION ( ‘L’ IN 'HELLO WORLD' );

Output:

3

Explanation:
The position of the first appearance of the substring is returned as the result.

Example 2:

mysql> SELECT POSITION ( ‘l’ IN 'HELLO WORLD' );

Output:

3

Explanation:
The position of the first appearance of the substring is returned as the result.

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status