Mysql LTRIM
From w3cyberlearnings
Contents |
MySQL LTRIM Function
This function removes whitespace based on the left side of a given string.
Syntax LTRIM
- Str: A String input
LTRIM(Str);
Example 1
mysql> SELECT LTRIM(' she is');
+---------------------+
| LTRIM(' she is') |
+---------------------+
| she is |
+---------------------+
1 row in set (0.00 sec)
Output
mysql> SELECT LTRIM(' she is'),' she is';
+---------------------+-----------+
| LTRIM(' she is') | she is |
+---------------------+-----------+
| she is | she is |
+---------------------+-----------+
1 row in set (0.00 sec)
