wordpress批量移动文章分类SQL语句，根据ID重设置

根据ID重设置wordpress批量移动文章分类SQL方式，

update wp_term_relationships
set term_taxonomy_id=[新分类ID]
WHERE term_taxonomy_id = '[原分类ID]' AND object_id IN ([文章ID1],[文章ID2],[文章ID3]）

update wp_term_relationships

set term_taxonomy_id=[新分类ID]

WHERE term_taxonomy_id = '[原分类ID]' AND object_id IN ([文章ID1],[文章ID2],[文章ID3]）

例：

update wp_term_relationships
set term_taxonomy_id=2
WHERE term_taxonomy_id = '1195914' AND object_id IN (800779,811835,761739,734283,734279,734204,872727,1127920,1190594,1196763,1142679,1142677,1142675,1142682,1142680,1142678,1142676,1091160,1058884,1059856,1058885,1125105,1065308,1039157,1071397,793484,1041312,1059746,1062792,1041790,1071383,1039237,1143402,1041363,1041682,1043092)

update wp_term_relationships

set term_taxonomy_id=2

WHERE term_taxonomy_id = '1195914' AND object_id IN (800779,811835,761739,734283,734279,734204,872727,1127920,1190594,1196763,1142679,1142677,1142675,1142682,1142680,1142678,1142676,1091160,1058884,1059856,1058885,1125105,1065308,1039157,1071397,793484,1041312,1059746,1062792,1041790,1071383,1039237,1143402,1041363,1041682,1043092)