MySQL views explained with WordPress database examples
Create MySQL views to encapsulate complex WordPress JOIN queries into reusable virtual tables you can query from PHP with wpdb.
Manage WordPress database migrations with dbDelta and versioned SQL scri ...
Build a reliable WordPress plugin migration system with dbDelta, version options and ordered migration functions that run automatically on update.
MySQL subqueries explained with WordPress database examples
Use MySQL IN, NOT EXISTS and derived table subqueries to filter and clean WordPress database records efficiently.
MySQL JOINs explained with WordPress database examples
Learn INNER JOIN, LEFT JOIN and multi-table joins with practical WordPress SQL examples for posts, meta and taxonomy tables.
MySQL transactions: use COMMIT and ROLLBACK in WordPress
Wrap multi-table inserts and updates in MySQL transactions with START TRANSACTION, COMMIT and ROLLBACK via $wpdb.
Aggregate and sort WordPress data with MySQL GROUP BY and ORDER BY
Use MySQL GROUP BY, ORDER BY, HAVING and aggregate functions to count and summarise WordPress database records.
Use EXPLAIN to find and fix slow MySQL queries
Learn how to read MySQL EXPLAIN output to identify missing indexes and eliminate full-table scans.
Search WordPress Posts by Keyword with WP_Query and $wpdb LIKE Queries
Get links to all posts that contain a specific phrase Hi all! Today we continue with SEO questions. Imagine a large website with thousands of pages. We have to find a word, or a part of a word, in the content of the posts, output links to all pages that contain it, and then be…