There is also a new intersect clause to aid with sets. MySQL 8.0 also supports new commands that are not included in MySQL 5.7. One example is EXPLAIN ANALYZE, which is a big boon to query tuning.

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 ...