MySQL SUBSTRING_INDEX() Function

The name of the pictureThe name of the pictureThe name of the pictureClash 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