第一步：
update `zh_ecms_company` set classid=47 WHERE zone in(330102,330103,330104,330105,330106,330108,330109,330110,330122,330127,330182,330183,330185)
第二步：
update `zh_ecms_company_data_1` set classid=47 WHERE id in(select id from `zh_ecms_company` where classid=47)
第三步：
update `zh_ecms_company_index` set classid=47 WHERE id in(select id from `zh_ecms_company` where classid=47)
然后更新数据库缓存，OK。
原文：http://www.cnblogs.com/zl0372/p/diguo.html