LTRIM() Function in MySQL
Last Updated :
03 Dec, 2020
LTRIM() :
This function in MySQL is used to remove leading spaces from a string.
Syntax :
LTRIM(str)
Parameter :
It accepts one parameter as mentioned above and described below as follows.
- str – The string from which we want to remove leading spaces.
Returns :
It returns a string after truncating all leading spaces.
Example-1 :
Removing all the leading spaces of a given string using LTRIM Function.
SELECT ' geeksforgeeks' As OriginalString,
LTRIM (' geeksforgeeks') AS LeftTrimmedString;
Output :
OriginalString |
LeftTrimmedString |
geeksforgeeks |
geeksforgeeks |
Example-2 :
Removing all the leading spaces of a given string using LTRIM Function.
SELECT ' MySQL' AS String,
RTRIM ('MySQL') AS Tstring;
Output :
String |
Tstring |
MySQL |
MySQL |
Example-3 :
LTRIM Function can also be used to remove all the leading spaces of column data. To demonstrate create a table named Employee.
CREATE TABLE Employee
(
Employee_id INT AUTO_INCREMENT,
Employee_name VARCHAR(100) NOT NULL,
Joining_Date DATE NOT NULL,
PRIMARY KEY(Employee_id )
);
Inserting some data to the Employee table :
INSERT INTO Employee
(Employee_name, Joining_Date )
VALUES
(' Ananya Majumdar', '2000-01-11'),
(' Anushka Samanta', '2002-11-10' ),
(' Aniket Sharma ', '2005-06-11' ),
(' Anik Das', '2008-01-21' ),
(' Riya Jain', '2008-02-01' ),
(' Tapan Samanta', '2010-01-11' ),
(' Deepak Sharma', '2014-12-01' ),
(' Ankana Jana', '2018-08-17'),
(' Shreya Ghosh', '2020-09-10') ;
So, the Employee Table is as follows.
select * from Employee ;
Output :
Employee_id |
Employee_name |
Joining_Date |
1 |
Ananya Majumdar |
2000-01-11 |
2 |
Anushka Samanta |
2002-11-10 |
3 |
Aniket Sharma |
2005-06-11 |
4 |
Anik Das |
2008-01-21 |
5 |
Riya Jain |
2008-02-01 |
6 |
Tapan Samanta |
2010-01-11 |
7 |
Deepak Sharma |
2014-12-01 |
8 |
Ankana Jana |
2018-08-17 |
9 |
Shreya Ghosh |
2020-09-10 |
Now, we are going to remove all leading spaces from the Employee_name column.
SELECT
Employee_id, Employee_name,
LTRIM( Employee_name) AS TrimmedEname
FROM Employee ;
Output :
Employee_id |
Employee_name |
TrimmedEname |
1 |
Ananya Majumdar |
Ananya Majumdar |
2 |
Anushka Samanta |
Anushka Samanta |
3 |
Aniket Sharma |
Aniket Sharma |
4 |
Anik Das |
Anik Das |
5 |
Riya Jain |
Riya Jain |
6 |
Tapan Samanta |
Tapan Samanta |
7 |
Deepak Sharma |
Deepak Sharma |
8 |
Ankana Jana |
Ankana Jana |
9 |
Shreya Ghosh |
Shreya Ghosh |
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...