27 Handy SQL Query Hacks for WordPress

If you have been managing a WordPress website for a while then you probably know that this content management platform uses a MySQL database to store every bit of information it needs to display your pages and apply your chosen settings. WordPress and MySQL make a great partnership; both are free, and using WordPress means a constant source of new plugins and features to make life easier. But you can manage your site just as well, and in some cases even better, from phpMyAdmin if only you know how to work from the MySQL side. That, of course, is just a matter of running queries against the database WordPress relies on.
It’s not essential to know MySQL to build a WordPress site, but knowing how to run some useful queries that will save you headaches is definitely an advantage.
How to Manage your WordPress Database
If you’re familiar with phpMyAdmin and SQL (structured query language), skip ahead, but if this is new:
You can find phpMyAdmin on your hosting cPanel if you don’t know where to access it. When the console opens, select your site database from the list on the left. It should reflect the domain or username given to you when your WordPress site was set up, followed
Source: https://managewp.org/articles/15422/27-handy-sql-query-hacks-for-wordpress

source https://williechiu40.wordpress.com/2017/06/29/27-handy-sql-query-hacks-for-wordpress/