{"id":7580,"date":"2019-04-09T17:38:31","date_gmt":"2019-04-10T00:38:31","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=7580"},"modified":"2023-10-12T21:56:33","modified_gmt":"2023-10-13T04:56:33","slug":"mysql-ltrim-function","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-string-functions\/mysql-ltrim-function\/","title":{"rendered":"MySQL LTRIM() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the LTRIM()<\/code> function to remove all leading spaces of a string.<\/p>\n\n\n\n

MySQL LTRIM() function overview<\/h2>\n\n\n\n

The LTRIM()<\/code> function takes a string argument and returns a new string with all the leading space characters removed.<\/p>\n\n\n\n

The following illustrates the syntax of the LTRIM()<\/code> function:<\/p>\n\n\n

LTRIM(str)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, the str<\/code> argument is the string that you want to remove all the leading spaces.<\/p>\n\n\n\n
If the str<\/code> is NULL, the LTRIM()<\/code> function returns NULL<\/a>.<\/p>\n\n\n\n
Note that to remove the trailing spaces from a string, you use the RTRIM()<\/a><\/code> function. To remove both leading and trailing spaces from a string, you use the TRIM()<\/a><\/code> function.<\/p>\n\n\n\n
MySQL LTRIM() function examples<\/h2>\n\n\n\n
Let’s see some examples of using the LTRIM()<\/code> function.<\/p>\n\n\n\n
1) Using LTRIM() function with a literal string<\/h3>\n\n\n\n
The following statement uses the LTRIM()<\/code> function to remove all leading spaces of the string ' MySQL Tutorial'<\/code>:<\/p>\n\n\n
SELECT<\/span> \n    LTRIM<\/span>('   MySQL Tutorial'<\/span>) result<\/span>;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Here is the output:<\/p>\n\n\n
+----------------+<\/span>\n| result         |\n+----------------+<\/span>\n| MySQL Tutorial |\n+----------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
2) Using LTRIM() function to update data in a table<\/h3>\n\n\n\n
We’ll use the customers<\/code> table from the sample database<\/a> for the demonstration:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
The following query uses the LTRIM()<\/code> function to remove all leading spaces of the addresses in the addressLine1<\/code> column of the customers<\/code> table.<\/p>\n\n\n
UPDATE<\/span>\n    customers\nSET<\/span> \n    addressLine1 = LTRIM<\/span>(addressLine1);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Summary<\/h2>\n\n\n\n
    \n
  • Use the LTRIM()<\/code> function to remove all the leading spaces of a string.<\/li>\n<\/ul>\n
    \n\t
    \n\t\t
    Was this tutorial helpful? <\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t