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