UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Mining Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Blacksmithing Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='First Aid Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Fishing Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Cooking Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Herbalism Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Skinning Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Lockpicking Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Leatherworking Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname` LIKE '%Trainer and Supplies%';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname` LIKE '%Trainer & Supplies%';