LTRIM to remove space Prefix to a string

MySQL Ltrim
SELECT LTRIM('')// Output


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 All rights reserved worldwide Privacy Policy Disclaimer