[Prestashop] Disabling country list in one go

Default installation prestashop included all the country in the world, as for me I don’t realy need all of them to be enable which because I’m only selling items in my local country only.

This which require me to disable all 200+ entry which is a tremendous clicking task, but someone posted this in the prestashop forum which only require 1 SQL query statement to disable all of the entry beside your choosing:

UPDATE ps_country SET active=0 WHERE iso_code NOT LIKE 'MY'

of course you need to change the ps_ to your database prefix :)

Cheers!