MySQL SUBSTRING_INDEX() Function
Multi tool use
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
MySQL SUBSTRING_INDEX() Function
❮ MySQL Functions
Example
Return a substring of a string before a specified number of
delimiter occurs:
SELECT SUBSTRING_INDEX("www.w3schools.com", ".", 1);Try it Yourself »
Definition and Usage
The SUBSTRING_INDEX() function returns a substring of a string before a
specified number of
delimiter occurs.
Syntax
SUBSTRING_INDEX(string, delimiter, number)Parameter Values
| Parameter | Description |
|---|---|
| string | Required. The original string |
| delimiter | Required. The delimiter to search for |
| number | Required. The number of times to search for the delimiter. Can be both a positive or negative number. If it is a positive number, this function returns all to the left of the delimiter. If it is a negative number, this function returns all to the right of the delimiter. |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Return a substring of a string before a specified number of
delimiter occurs:
SELECT SUBSTRING_INDEX("www.w3schools.com", ".", 2);Try it Yourself »
❮ MySQL Functions
