phpmyadmin export selected data from SQL to excel

Question

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.

What version of phpmyadmin are you using? After you run the query, make sure to use the Export link below the table, not the Export Tab at the top of the page. — Michael
– Michael, Commented Dec 10, 2014 at 3:03
You solved my question dude, how can i give you a + point or something for your answer? Thanks very much for your time and effort. — Allan-LaLa De Joya
– Allan-LaLa De Joya, Commented Dec 10, 2014 at 3:10

Michael · Accepted Answer · 2014-12-10 03:14:41Z

23

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

answered Dec 10, 2014 at 3:14

Michael

2,1651 gold badge21 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

AwokeKnowing Over a year ago

when I click that option on a query with subqueries it forgets the query and goes to the whole table.

Slbox Over a year ago

@AwokeKnowing - it does appear that way, but go ahead and follow through to completion. The export will only contain the data you selected, despite appearances.

Collectives™ on Stack Overflow

phpmyadmin export selected data from SQL to excel

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related