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=TRIM(name)
Rread more on UPDATE Query
We can add space to a column and then display after removing
SELECT concat(' ',name), ltrim(concat(' ',name)) from student
Rread more on CONCAT
