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)
Read 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
Read more on CONCAT
This article is written by plus2net.com team.
▼ More on String