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, 247🔥, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...