Run SQL Query for WordPress
You don’t need to be a master of PHP or MySQL to start a WordPress site but knowing a bit about them helps. Plenty of people use phpMyAdmin and similar tools to make changes to their database. Thanks to Run SQL Query, you can execute SQL queries without any other tool. You will be able to run queries against all your tables and export the results to CSV.
This plugin lets you execute SQL statements against your main database, so you will want to take extreme care and have your DB backed up. Run SQL Query for WordPress is available as a free download. You can find out more about it here.