phpmysqldatabaseexcelphpmyadmin

phpmyadmin export selected data from SQL to excel

I have a problem where I need to just export selected data from my phpmyadmin, i'm using XAMPP.

I have a table named "Tbl_Records" and I only need to get all the data of year 2014 or just a specific year in that table.

I tried 

Select * From Tbl_Records Where Year = 2014

in Phpmyadmin to get only the specific year and then exported the data but it still exported everything.

Solution

  • You need to use the Export link located under the data from the query and not the Export tab at the top, as shown in the picture below:

    enter image description here