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%';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Portal Trainer';
UPDATE `creature_template` SET `class`='8' WHERE `subname`='Portal Trainer';
UPDATE `creature_template` SET `trainer_type`='3' WHERE `subname`='Pet Trainer';
UPDATE `creature_template` SET `trainer_type`='3' WHERE `subname`='Demon Trainer';
UPDATE `creature_template` SET `class`='3' WHERE `subname`='Demon Trainer';
UPDATE `creature_template` SET `trainer_type`='3' WHERE `entry`='11696';
UPDATE `creature_template` SET `class`='3' WHERE `entry`='11696';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname` LIKE '%Enchanter%';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname` LIKE '%Leatherworker%';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname` LIKE '%Herbalist%';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname` LIKE '%Blacksmith';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname` LIKE '%Alchemist%';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname` LIKE '%skinn%';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname` LIKE '%tailor';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname` LIKE '%engineer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname` LIKE '%Fisherman';