Right now the QueryBuilder::update() method uses wpdb::update() under the hood. This limits us to what that method is capable of. For example, want a WHERE X IN (SELECT...) clause in your update method? Too bad. 馃槶
By switching to running simple SQL under the hood we make more complex conditions possible without much effort. The WHERE clause is simply converted to SQL and tacked onto the end, getting the full power of the Query Builder behind complex update queries. Furthermore, update can also receive:
- A Query
- ORDER BY clause
- LIMIT clause
Right now the
QueryBuilder::update()method uses wpdb::update() under the hood. This limits us to what that method is capable of. For example, want aWHERE X IN (SELECT...)clause in your update method? Too bad. 馃槶By switching to running simple SQL under the hood we make more complex conditions possible without much effort. The WHERE clause is simply converted to SQL and tacked onto the end, getting the full power of the Query Builder behind complex update queries. Furthermore, update can also receive: