Changing value's, query help.

[extreme101]

I have a table i need to edit
i want to replace all values of 3 to 1 within a column.

eg. change blah to 3 where blah = 1

just not 100% sure on the right syntax.
hopefully someone can point me in the right direction.

[M.Zeb Khan]

UPDATE tablename SET blah = '3' WHERE blah = '1';

[extreme101]

thanks worked perfect.

[M.Zeb Khan]

extreme101,

My pleasure

.