Mysql-help: ibatis batch update Mysql data

Scenario: update the value of all fields that meet the condition according to the message code and status. The value is & quot; T & quot ;. How to batch update? If it is a single condition, use the iterate label to put the value in (& #39; xxx & #39;, & #39; yyy & #39;) for a loop, how does mysql handle multiple conditions after where? Ibatismysql batch update database

Scenario: update all fields that meet the conditions based on the message code and status to "T ". How to batch update? If it is a single condition, use the iterate label to put the value in ('XXX', 'yyy') for a loop. what should mysql do when there are multiple conditions following where?