Deleting WordPress records based on Nested Selects
Last week I was helping with a task for deleting terms from the WordPress database based on an array of IDs from a select statement. Since I have a thing for database systems (spent a few years playing in various mid-size and large projects with Oracle and PostgreSQL databases before migrating to MySQL) I thought it was a 20sec job to build the query having the select ready and delete the data. However, I got stuck in the process and took me about 15min to actually form the proper statement. The final code looks like that (with a bit different… Continue Reading