Tutorial Gateway

MySQL POSITION Function

by

The MySQL Position function is a synonym of Locate Function. This String Function is used to find the index position of first occurrence of a substring in a string expression.

In this article, we will show you, How to write String Position in MySQL to find the substring index position with an example.

MySQL String Position Syntax

The basic syntax of string Position in MySQL is as shown below:

POSITION(Substring IN String)

MySQL Position Function Example 1

The String Position Function is used to finds index position of a substring. The following query will show multiple ways to use this String Position function.

SELECT POSITION('a' IN 'tutorialgateway');

SELECT POSITION('g' IN 'tutorialgateway');

SELECT POSITION('o' IN 'Hello World');

OUTPUT

MySQL POSITION Function 1

This is an another example of this position function.

SELECT POSITION('abc' IN 'This is abc working in abc Company');

SELECT POSITION('in' IN 'This is abc working in abc Company');

SELECT POSITION('is' IN 'This is abc working in abc Company');

OUTPUT

MySQL POSITION Function 2

MySQL Position String Example 2

In this example, we implement this MySQL string Position on different columns present in the employe table.

The following statement will find the first occurrence position of @, com and mail words from Email column.

SELECT FirstName,
       LastName,
       DepartmentName,
       Email,
       POSITION('@' IN Email),
       POSITION('com' IN Email),
       POSITION('mail' IN Email) AS Mail
 FROM `MySQL Tutorial`.employe;

OUTPUT

MySQL POSITION Function 3

Thank You for Visiting Our Blog