[SOLVED] Modify column values

[SeanFromIT]

Can someone show me the SQL equivalent of the following?

 

for all rows in a single column {

if value = 'example'

  set value = 'answer'

}

[AndyB]

update tablename set value='answer' where value='example'

[SeanFromIT]

Thanks!