how to remove whitespace between two words in mysql
I have a record like Z Ion Fort. Now I want to combine the word like as
follows ZIon Fort,for that I had written a update query like
update sample1 set sname=replace(sname,' Ion ','Ion ');
But it is not working.