Combine two UPDATE statements

[quote user="lbgto"]
[/quote]
Welcome to the forum!
The subject of your thread is not self-explanatory. We need some more information. []

Hint
If you have something like thisupdate table
set col1='value1'
where col2='test'
update
table
set col1='value2'
where col2<>'test'You can combine it
to
update table
set col1=case when col2='test' then 'value1' else 'value2' end