In this tutorial, you will know how to export a query result in excel CSV from MySQL PHPMyAdmin. Sometime we need to just export the query result in excel or csv for reports purpose or for any purposes, so this will help you out to achieve this.
You can use this below query:-
CREATE TABLE tmp_export SELECT * FROM other_table WHERE val=1
The above query will create a table “tmp_export” with the query result and now you can directly export the “tmp_export” table from phpMyadmin in any of your required formats and it will be downloaded on your machine.