RetroSearch Browse

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://www.geeksforgeeks.org/sql/ltrim-function-in-mysql/ below:

LTRIM() Function in MySQL - GeeksforGeeks

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

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4