MySQL remove all spaces - urgent (last thing I need)

[Vivid Lust]

Is there any way to remove all spaces in mySQL so:

 

sp ace

 

becomes

 

space

 

If someone could give me this query, I would be very greatfull, thanks lots.

[mikesta707]

what do you mean in mysql? do you mean in a mysql query? surely str_replace() will suit your needs there. Can you explain your question a little more

[Maq]

This should work.

 

UPDATE [table_name] SET [column]=(REPLACE ([column], ' ', ''));