You cannot use a compound condition to update a row.

Name: You cannot use a compound condition to update a row.
Brand: Quizplus
Rating: 4.7 (38 reviews)

Question

Quizplus · Accepted Answer

You can use a compound condition to select the rows you want to update, but when it comes to updating the rows, you need to specify each condition separately. For example, instead of writing UPDATE table SET column='value' WHERE condition1 AND condition2, you would write UPDATE table SET column='value' WHERE condition1; UPDATE table SET column='value' WHERE condition2;.

You Cannot Use a Compound Condition to Update a Row