LTRIM() - Left-Trimming String
Q
How to trim off space characters from a string at the left end using the LTRIM() function?
✍: FYIcenter.com
A
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, 1145🔥, 0💬
Related Topics:
