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=LTRIM(name)

Read more on UPDATE Query

We can add space to a column and also display the same after removing space.
SELECT concat('    ',name), ltrim(concat('   ',name))  from student

Read more on CONCAT

Subscribe to our YouTube Channel here


* indicates required
Subscribe to plus2net

    Post your comments , suggestion , error , requirements etc here .

    SQL Video Tutorials

    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2023 All rights reserved worldwide Privacy Policy Disclaimer