
START TRANSACTION;

UPDATE `multi_lang` SET `content` = 'Accounting / Finance / Insurance Jobs' WHERE `foreign_id` = 1 AND `content` = 'Accounting/Finance/Insurance Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Administrative / Clerical Jobs' WHERE `foreign_id` = 2 AND `content` = 'Administrative/Clerical Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Banking / Real Estate / Mortgage Professionals Jobs' WHERE `foreign_id` = 3 AND `content` = 'Banking/Real Estate/Mortgage Professionals Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Biotech / R&D / Science Jobs' WHERE `foreign_id` = 4 AND `content` = 'Biotech/R&D/Science Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Building Construction / Skilled Trades Jobs' WHERE `foreign_id` = 5 AND `content` = 'Building Construction/Skilled Trades Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Business / Strategic Management Jobs' WHERE `foreign_id` = 6 AND `content` = 'Business/Strategic Management Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Creative / Design Jobs' WHERE `foreign_id` = 7 AND `content` = 'Creative/Design Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Customer Support / Client Care Jobs' WHERE `foreign_id` = 8 AND `content` = 'Customer Support/Client Care Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Editorial / Writing Jobs' WHERE `foreign_id` = 9 AND `content` = 'Editorial/Writing Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Education / Training Jobs' WHERE `foreign_id` = 10 AND `content` = 'Education/Training Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Food Services / Hospitality Jobs' WHERE `foreign_id` = 12 AND `content` = 'Food Services/Hospitality Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Installation / Maintenance/Repair Jobs' WHERE `foreign_id` = 14 AND `content` = 'Installation/Maintenance/Repair Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'IT / Software Development Jobs' WHERE `foreign_id` = 15 AND `content` = 'IT/Software Development Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Logistics / Transportation Jobs' WHERE `foreign_id` = 17 AND `content` = 'Logistics/Transportation Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Manufacturing / Production/Operations Jobs' WHERE `foreign_id` = 18 AND `content` = 'Manufacturing/Production/Operations Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Marketing / Product Jobs' WHERE `foreign_id` = 19 AND `content` = 'Marketing/Product Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Medical / Health Jobs' WHERE `foreign_id` = 20 AND `content` = 'Medical/Health Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Project / Program Management Jobs' WHERE `foreign_id` = 22 AND `content` = 'Project/Program Management Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Quality Assurance / Safety Jobs' WHERE `foreign_id` = 23 AND `content` = 'Quality Assurance/Safety Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Sales / Retail / Business Development Jobs' WHERE `foreign_id` = 24 AND `content` = 'Sales/Retail/Business Development Jobs' AND `model` = "pjCategory" AND `field` = "name";

UPDATE `multi_lang` SET `content` = 'Security / Protective Services Jobs' WHERE `foreign_id` = 25 AND `content` = 'Security/Protective Services Jobs' AND `model` = "pjCategory" AND `field` = "name";

COMMIT;