Hi all!

I have one text field in a table that, in some cases, contains double
spaces between words. How do I replace those double spaces with a
single space?


Greetings,
   Evert

On 12 Nov, 08:10, emeu...@gmail.com wrote:
> Hi all!
>
> I have one text field in a table that, in some cases, contains double
> spaces between words. How do I replace those double spaces with a
> single space?
>
> Greetings,
>    Evert

SELECT REPLACE(text_field,'  ',' ') FROM table

emeulie@gmail.com wrote:
> I have one text field in a table that, in some cases, contains double
> spaces between words. How do I replace those double spaces with a
> single space?

I think you could use the REPLACE keyword 
(http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace) 
and the query would look something like this I guess:

UPDATE table SET table.textfield = REPLACE(table.textfield, '  ', ' ');

Jonathan