|
|
Posted by Richard on 08/21/07 12:00
I have tried:
UPDATE [LISTINGS] SET [MEDAL_NAME] = 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 near
'[LISTINGS] set [MEDAL_NAME] = replace([MEDAL_NAME],'[War
Plaque]','[Memorial Pla' at line 1
????????
"Richard" <sales@justmedals.com> wrote in message
news:hmAyi.23818$ie3.23309@newsfe3-gui.ntli.net...
> Hi there.
> Am a total newbie to sql language.
>
> Does mySql have a find and replace function
> or can a command be written to perform such
> a task.
>
> In the table I have a column named MEDAL_NAME
>
> I wish to change all entries in that colum that
> contain the words "War Plaque" to "Memorial Plaque"
>
> Any pointers gratefully received
>
>
begin 666 b_help.png
MB5!.1PT*&@H````-24A$4@````L````+" ,```"><H<4````!&=!34$``*_(
M-P6*Z0```!ET15AT4V]F='=A<F4`061O8F4@26UA9V5296%D>7')93P````)
M4$Q410```,S,_P```!>I-"0````#=%).4___`-?*#4$```!3241!5'C:8F!B
M8H `)B: `&)@8F"$``8F@ !B`#$9("1 `(%(, .(``*(`:($S 4(( @;0@`$
M$#(;(( 88,8`V0`!A"P.$$#(Y@,$$ .2O0`!!@`7Q0!=OLO%,P````!)14Y$
$KD)@@@``
`
end
Navigation:
[Reply to this message]
|