THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL POSITION() Function

❮ MySQL Functions

Example

Search for "3" in string "W3Schools.com", and return position:

SELECT POSITION("3" IN "W3Schools.com") AS MatchPosition;
Try it Yourself »

Definition and Usage

The POSITION() function returns the position of the first occurrence of a substring in a string.

If the substring is not found within the original string, this function returns 0.

This function performs a case-insensitive search.

Note: The LOCATE() function is equal to the POSITION() function.

Syntax

POSITION(substring IN string)

Parameter Values

Parameter Description
substring Required. The substring to search for in string
string Required. The original string that will be searched

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Search for "COM" in string "W3Schools.com", and return position:

SELECT POSITION("COM" IN "W3Schools.com") AS MatchPosition;
Try it Yourself »

Example

Search for "a" in CustomerName column, and return position:

SELECT POSITION("a" IN CustomerName)
FROM Customers;
Try it Yourself »

❮ MySQL Functions