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




Subscribe to our mailing list

* indicates required
Subscribe to plus2net
Your Rating


Google+

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




Subscribe to our mailing list

* indicates required
Subscribe to plus2net




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