You are here:Home » Software Development » SQL Remove BLANK spaces in varchar field

SQL Remove BLANK spaces in varchar field

update formers set
    former_title = replace(former_title, ' ', '');

update formers set
    former_title = replace(former_title, '    ', '');

update formers set
    former_title = replace(former_title, '    ', '');


http://forums.mysql.com/read.php?10,376702,377885#msg-377885

1 comment:

  1. UTSI provides Website Marketing, some of the most contemporary E-Marketing services, assuring greater success, higher traffic and enhanced brand image to our entire client's websites.
    Website Marketing

    ReplyDelete

Please write us a feedback. Thank you!