THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL INSTR() Function

❮ MySQL Functions

Example

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

SELECT INSTR("W3Schools.com", "3") AS MatchPosition;
Try it Yourself »

Definition and Usage

The INSTR() function returns the position of the first occurrence of a string in another string.

This function performs a case-insensitive search.

Syntax

INSTR(string1, string2)

Parameter Values

Parameter Description
string1 Required. The string that will be searched
string2 Required. The string to search for in string1. If string2 is not found, this function returns 0

Technical Details

Works in: From MySQL 4.0

More Examples

Example

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

SELECT INSTR("W3Schools.com", "COM") AS MatchPosition;
Try it Yourself »

Example

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

SELECT INSTR(CustomerName, "a")
FROM Customers;
Try it Yourself »

❮ MySQL Functions