CODEWITHSUNDEEP
phpmysqldatabaseexcelphpmyadmin
Allan-LaLa De Joya
Allan-LaLa De Joya

Reputation: 143

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.

Upvotes: 13

Views: 13781

Answers (1)

Michael
Michael

Reputation: 2165

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

Upvotes: 23

Related Questions