Most of time we need to update multiple row at a time or in single mysql query, So most of developer use iterate the update query and execute many time. This is not good practice.

So I want to make an update in MySQL where a value is updated if two conditions are true. So I have data in columns name and status. If the name and status match foo and d, then I want to change ...