Adrian, I will suggest once more that you replace all tabs with a space as well, and maybe all carriage returns as well (for good measure).
This time I'll write out the queries for you: UPDATE hotel SET nome_hotel=REPLACE(nome_hotel, "\t", " "); UPDATE hotel SET nome_hotel=REPLACE(nome_hotel, "\r", " "); Then, when that's finished, you might have to try replacing all double spaces with single spaces again, until the data is correct. Steve Meyers > -----Original Message----- > From: Adrian D'Costa [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 22, 2001 2:29 AM > To: Clyde Jones > Cc: Mysql Mailing List > Subject: Re: how to get the correct result -- Thrid Time -- > > > On Sat, 20 Oct 2001, Clyde Jones wrote: > > > Did you try that? replace should recursively replace ALL double spaces, > > if it is a problem just run and rerun the query > > > > UPDATED hotel > > set nome_hotel replace(nome_hotel, " ", " ") > > > > until all the double spaces are gone. > > Ok. I tried it but of no use. It replaced three records and after that > none even though I tried again and again... > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php