Posted by Rik on 08/21/07 12:20

On Tue, 21 Aug 2007 14:00:32 +0200, Richard <sales@justmedals.com> wrote=
:

>
> I have tried:
> UPDATE [LISTINGS] SET [MEDAL_NAME] =3D replace( [MEDAL_NAME], '[War =

> Plaque]',
> '[Memorial Plaque]' )
>
> MySQL said:
>
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use n=
ear
> '[LISTINGS] set [MEDAL_NAME] =3D replace([MEDAL_NAME],'[War
> Plaque]','[Memorial Pla' at line 1
>
> ????????

I assume the blockquotes aren't there...

UPDATE `LISTINGS` SET `MEDAL_NAME` =3D REPLACE(`MEDAL_NAME`, 'War =

Plaque','Memorial Plaque')

(Are you sure the tablename & fielname are all in capitals? Default woul=
d =

be lowercase AFAIK).
-- =

Rik Wasmus

• Next in forum: Re: mySql - find and replace.
• Prev in forum: Re: mySql - find and replace.
• Thread view: Re: mySql - find and replace.

[Reply to this message]