Changing identical values to new values

[ztrex]

I need to change a set of identical values (CHAR type) to a new value, hopefully all in one string/command. I tried doing this:

update table
set column1 = newvalue where column1 = oldvalue

but it didn't work. ideas?

 

[Cagliostro]

table means a table name or a keyword? John Fill

ivfmd@mail.md

 

[ztrex]

table name....