MariaDB POSITION() Function

The MariaDB POSITION() function returns the location of the first occurrence of a specified substring in a given string. If the substring is not found within the given string, this function returns 0.

This function performs a case-insensitive search. Note that the first position in string starts with 1.

The POSITION() function is a synonym for the LOCATE() function.

Syntax

POSITION(substring, string, start_position)

Parameters

Return Value

Returns the location of the first occurrence of the substring in the string.

Example 1:

The example below shows the usage of POSITION() function.

SELECT POSITION('A', 'AlphaCodingSkills.com');
Result: 1

SELECT POSITION('Coding', 'AlphaCodingSkills.com');
Result: 6

SELECT POSITION('.com', 'AlphaCodingSkills.com');
Result: 18

SELECT POSITION('l', 'AlphaCodingSkills.com');
Result: 2

SELECT POSITION('l', 'AlphaCodingSkills.com', 5);
Result: 15

SELECT POSITION('Z', 'AlphaCodingSkills.com');
Result: 0

SELECT POSITION('ABC', 'AlphaCodingSkills.com');
Result: 0

Example 2:

Consider a database table called Employee with the following records:

In the query below, the POSITION() function is used to extract the country code from the PhoneNumber column records.

SELECT *, SUBSTR(PhoneNumber, 1, POSITION('-', PhoneNumber) - 1) AS CountryCode 
FROM Employee;

This will produce the result as shown below: