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, 243🔥, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...