sql query to replace data in a table

What is the SQL command to replace the value in a field? (not add a new value)
Thanks in advance.

UPDATE tablename SET colname='newvalue' WHERE colname='oldname';