Collections:
LTRIM() - Left-Trimming String
How to trim off space characters from a string at the left end using the LTRIM() function?
✍: FYIcenter.com
LTRIM(str) is a MySQL built-in function that trims off space characters from a string at the left end. For example:
SELECT LTRIM(' dba.FYIcenter.com'); -- +-------------------------------+ -- | LTRIM(' dba.FYIcenter.com') | -- +-------------------------------+ -- | dba.FYIcenter.com | -- +-------------------------------+
Reference information of the LTRIM() function:
LTRIM(str): modstr Returns the string str with leading space characters removed. Returns NULL if str is NULL. Arguments, return value and availability: str: Required. The string that will be left-trimmed from. modstr: Return value. The modified string after trimming. Available since MySQL 4.0.
Related MySQL functions:
⇒ MID() - Synonym for SUBSTRING()
⇐ LPAD() - Left-Padding String
2023-11-11, 251🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...