Hello,

I need to select all products from a certain category out of my current database to export to another database.

How do I make the mysql query do it


This is what I was thinking but didnt work:

SELECT * ROWS FROM `zen_products` WHERE `master_categories_id` = 69

All Im trying to do is select all products that are in master category 69

Im sure this is really wrong however this is my first attempt at mysql syntax.