SUBSTRING() function in MySQL

Last Updated : 22 Sep, 2020

SUBSTRING() :
function in MySQL is used to derive substring from any given string .It extracts a string with a specified length, starting from a given location in an input string. The purpose of substring is to return a specific portion of the string.

Syntax :

  SUBSTRING(string, start, length)  OR  SUBSTRING(string FROM start FOR length)

Parameters :
This method accepts three-parameter as mentioned above and described below.

string –
Input String from which to extract.
start –
The starting position. If it is a positive number, this function extracts from the beginning of the string. If it is a negative number, this function extracts from the end of the string.
length –
It is optional. It identifies the number of characters to extract. If it is not given The whole string is returned from the starting position.

Example-1 :
Deriving substring from a given string without giving length parameter.

  SELECT SUBSTRING("GeeksForGeeks", 3) AS Sub_String;

Output :

Sub_String
eksForGeeks

Example-2 :
Deriving substring from a given string when length parameter is given.

  SELECT SUBSTRING("GeeksForGeeks", 3, 8) AS Sub_String;

Output :

Sub_String
eksForGe

Example-3 :
Deriving substring from a given string when starting position is -ve, i.e: starting from end.

   SELECT SUBSTRING("GeeksForGeeks", -3 ) AS Sub_String;

Output :

Sub_String
eks

Example-4 :
Extracting all substring from the text column in a Table.

Table : Student_Details

Student_Id	Student_Name
101	Virat
102	Rohit
103	Rahul
104	Sikhar

  SELECT SUBSTRING( Student_Name, 2 ) AS Sub_String FROM Student_Details ;

Output :

Sub_String
irat
ohit
ahul
ikhar

RTRIM() Function in MySQL

jana_sayantan

Improve

Article Tags :

SQL
mysql

Similar Reads

SUBSTRING_INDEX() function in MySQL

SUBSTRING_INDEX() function in MySQL is used to return a substring from a string before a specified number of occurrences of the delimiter. Syntax : SUBSTRING_INDEX( str, delim, count ) Parameter : This method accepts three-parameter as mentioned above and described below : str : The original string

2 min read

TRIM() Function in MySQL

TRIM() function in MySQL is used to clean up data. It is also used to remove the unwanted leading and trailing characters in a string. Syntax : TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str) Parameter : This method accepts three-parameter as mentioned above and described below : BOTH | LEADIN

2 min read

SUBDATE() function in MySQL

SUBDATE() function in MySQL is used to subtracts a time value (as interval) from a given date. Syntax : SUBDATE(date, INTERVAL expr unit) Parameter : This function accepts three parameters as given below : date : First specified date. expr : The value of the time/date interval to subtract. unit : Th

2 min read

RTRIM() Function in MySQL

RTRIM() : It is the function in MySQL that is used to remove trailing spaces from a string. Syntax : RTRIM(str) Parameter : RTRIM() function accepts one parameter as mentioned above and described below. str â€“The string from which we want to remove trailing spaces. Returns : It returns a string after

3 min read

RIGHT() Function in MySQL

RIGHT() function in MySQL is used to extract a specified number of characters from the right side of a given string. Second argument is used to decide, how many characters it should return. Syntax : RIGHT( str, len ) Parameter : This function accepts two parameter as mentioned above and described be

3 min read

POSITION() function in MySQL

POSITION() : This function in MySQL is used for finding the location of a substring in a string. It will return the location of the first occurrence of the substring in the string. If the substring is not present in the string then it will return 0. When searching for the location of a substring in

2 min read

TAN() Function in MySQL

TAN() function : This function in MySQL is used to return the tangent of a specified number. In any right triangle, the tangent of an angle is the length of the opposite side divided by the length of the adjacent side. Similarly, this can also be defined as tangent of x is the sine of x divided by t

1 min read

SQL Server SUBSTRING() Function

The SQL Server SUBSTRING function extracts a substring from a string, starting at a specified position and with an optional length. The SUBSTRING function also works in Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse. SyntaxThe SQL SUBSTRING function syntax is: SUBSTRING(in

3 min read

STRCMP() Function in MySQL

STRCMP() function in MySQL is used to compare two strings. If both of the strings are same then it returns 0, if the first argument is smaller than the second according to the defined order it returns -1 and it returns 1 when the second one is smaller the first one. Syntax : STRCMP(Str1, Str2) Param

3 min read

SQRT() Function in MySQL

The SQRT() function in MySQL calculates the square root of a non-negative number, returning NULL for negative inputs. It is a built-in function that provides high precision and is optimized for performance and making it ideal for mathematical and scientific applications. In the article, we will cove

4 min read