RTRIM to remove space suffix to a string

MySQL Rtrim
SELECT RTRIM('plus2net.com    ')// Output plus2net.com


To remove blank space after the name in our student table
UPDATE student SET name=RTRIM(name)
Read more on UPDATE Query
We can add space to a column and then display after removing
SELECT concat(name,'    '), RTRIM(concat(name, '   '))  from student
Read more on CONCAT

SQL String References LTRIM() : Removing space from LEFT TRIM : Removing space from both sides of the string

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-2024 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer