RTRIM to remove space suffix to a string

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

RTRIM with UPDATE

To remove blank space after the name in our student table
UPDATE student SET name=RTRIM(name)

Rread more on UPDATE Query

We can add space to a column and then display after removing
SELECT concat(name,'    '), RTRIM(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 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer