How Do I Export Part of a mySQL Table as XML in phpMyAdmin

I've got开发者_运维技巧 a mySQL database and I want to export part of the db (not the whole thing) as XML.

In phpMyAdmin, how do I export XML from a table where "series=10", for example? If I click the export tab, and the choose XML as the export option, then the whole table will be exported as XML. I only want part of the database exported as XML.

Any suggestions on how to do this?

Thank you.

-Laxmidi

Click the SQL tab. Craft a SQL statement that returns the 'part' of the db that you want exported. Then at the bottom of the page there is a 'Export' button. This will take you to a page that will allow you to export in various formats including XML.