Is there any way to have an UPDATE statement change a column value based on
the WHERE statement?

Essentially, I want to do something like this

UPDATE Actions SET ActionsSent = <foo> WHERE ActionsReceived = <bar>

where foo and bar change for multiple sets of values.  Is there a way to do
this in one SQL statement, or do I have to execute an UPDATE statement per
pair of values?

Thanks,
Waynn

Reply via email to