I'm far from the greatest of MySQL programmers (read, "dangerous beginner"), but I do use it for simple things. However, I have a problem that I don't know how to solve. Hoping someone might give me a hint.

I have a table full of information that I do NOT need. There are probably well over 1000 categories (which is in it's own column) in this table. What I need to do is to delete everything in this table except for the handful of categories I specifically want.

I know the query to use to delete specific categories. Thus, for another table, I use a query like this:

DELETE FROM 'TABLE' WHERE category IN
('510302',
'260404',
'510901');

But that query won't work with my current problem since I essentially want to delete everything in the table except for a few specific categories. Basically, I want to pick-out (and specifically name) 5-10 categories from this table and nuke everything else, permanently.

Any ideas on what query to use?

Thanks

Jim