Generate CSV based on MySQL query from phpMyAdmin

Can I generate a CSV file from phpMyAdmin based on a MySQL query?

For example, let's say I queried a table to return results for the word "image". Could I then produce a CSV with all of the records containing the word "image"?

 Answers

In PhpMyAdmin, go into the SQL tab and enter your query in there. Hit go, then click Export at the bottom of your results. You can select to export as a CSV.

In case you're interested, here's how to do it via SQL without PMA: How to output MySQL query results in CSV format?

---

What also works well is creating a table with the query and then export the table as usual, having all the options of phpmyadmin export available. Simply do something like this in SQL box of phpmyadmin

create table tmp_export
select * from xxxx

No problems with complex queries and large datasets using this approach.