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