Export specific column and row (is it possible?)

I need help with exporting my old database.

Let say my table have title, content and category

i wish to export whole table with titles and content of category number 3, so stuff from category 1 and 2 is not exportet.

p.S. i use Lampp localhost and i can delete category 1 and 2 and then export whole table contain just category 3.

If this is the only solution can yopu tell me what kind of SQL query i need to run? Or direct me to the command i need to use.

Thanks alot

 

CREATE TABLE MYEXPORT (SELECT * FROM TableName WHERE category=3);

Code (markup):

Now dump MYEXPORT
Regards

 

Thanks alot, this works.