You cannot use a compound condition with an UPDATE command.

Name: You cannot use a compound condition with an UPDATE command.
Brand: Quizplus
Rating: 4.8 (37 reviews)

Question

Quizplus · Accepted Answer

You can use a compound condition with an UPDATE command by using the logical operators AND or OR. For example:

UPDATE table_name
SET column1 = value1
WHERE condition1 AND condition2;

This will update column1 to value1 only for the rows where both condition1 and condition2 are true.

You Cannot Use a Compound Condition with an UPDATE Command