Generate CSV based on MySQL query from phpMyAdmin

Question

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"?

question from:https://stackoverflow.com/questions/6239956/generate-csv-based-on-mysql-query-from-phpmyadmin

Answer 1

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?