|
Posted by Geoff on 08/21/07 12:21
"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
>
>
http://www.w3schools.com/sql/sql_update.asp
UPDATE table_name
SET column_name = new_value
WHERE column_name = some_valuesomething like the above will dothat site is
quite handy when starting out i found
Navigation:
[Reply to this message]
|