LTRIM to remove space Prefix to a string

MySQL Ltrim
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




Your Rating




Post Comment This is for short comments only. Use the forum for more discussions.








HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
©2000-2019 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer