LTRIM to remove space Prefix to a string

SELECT LTRIM('  plus2net.com')// Output plus2net.com

LTRIM with UPDATE

UPDATE student SET name=LTRIM(name)

Read more on UPDATE Query

SELECT concat('    ',name), ltrim(concat('   ',name))  from student