quick way to delete all countries except for 2?

[dragon designs]

I am only going to be selling to 2 countries and was wondering if there is a quick way to delete the rest of them without going through the 2 step process for each one.

TIA

[jeking]

I have gone into phpMyAdmin and you can check several rows at a time. It's quicker than through Zen but still takes some time.

[Ajeh]

NOTE: based on the assumption that these are the 2 countries_id you do not wish to delete are 223 and 38 ...

NOTE: this also assumes you are wise enough to make a database backup before running these commands ...

DELETE from countries WHERE countries_id != 223 and countries_id !=38;

DELETE from zones WHERE zone_country_id != 223 and zone_country_id != 38;