LTRIM to remove space Prefix to a string
SELECT LTRIM(' plus2net.com')// Output plus2net.com
LTRIM with UPDATE
To remove blank space before the name in our student table
UPDATE student SET name=LTRIM(name)
Rread more on UPDATE Query
We can add space to a column and also display the same after removing space.
SELECT concat(' ',name), ltrim(concat(' ',name)) from student
Rread more on CONCAT
This article is written by plus2net.com team.
plus2net.com
▼ More on String
| 