Tutorial Gateway

MySQL Substr String

by

The MySQL Substr function is a synonym of a Substring function. It is one of the String Function that return a sub string. I suggest you to refer Substring function article to understand this function.

In this article, we will show you simple example to write Substr in MySQL with example.

SQL Substr String Syntax

The basic syntax of the Substr string in MySQL is as shown below.

SELECT SUBSTR(String, Position) FROM Source

SELECT SUBSTR(String FROM Position) FROM Source

SELECT SUBSTR(String, Position, Length) FROM Source

SELECT SUBSTR(String FROM Position FOR Length) FROM Source

The Substr string in MySQL also allows you to place negative values as the Position argument. If you use negative values, then substr will start looking from end to start position.

MySQL Substr String Example 1

The following query will show multiple ways to use this Substr function.

SELECT SUBSTR('MySQL Tutorial', 7) AS Substr1;

SELECT SUBSTR('MySQL Tutorial' FROM 9) AS Substr2;

SELECT SUBSTR('MySQL Tutorial', 3, 14) AS Substr3;

SELECT SUBSTR('MySQL Tutorial' FROM 3 FOR 11) AS Substr4;

OUTPUT

MySQL Substr String 1

MySQL Substr String Example 2

In this example, we will use negative values as the position argument in a substr function.

SELECT SUBSTRING('Tutorial Gateway', -7) AS Substr1;

SELECT SUBSTRING('Tutorial Gateway', -14, 8) AS Substr2;

OUTPUT

MySQL Substr String 2

Thank You for Visiting Our Blog