update wp_postmeta set `meta_value`=价格 WHERE `meta_key` ='价格字段' AND post_id IN (SELECT object_id AS post_id FROM `wp_term_relationships` WHERE term_taxonomy_id =分类id )
update wp_postmeta set `meta_value`='要改的值' WHERE `meta_key` ='要改的字段名' AND post_id IN (SELECT object_id AS post_id FROM `wp_term_relationships` WHERE term_taxonomy_id =分类id )

 

执行成功图供参考,另外搞之前先备份数据库有风险

声明:本站所有文章,如无特殊说明或标注,均为本站原创发布。任何个人或组织,在未征得本站同意时,禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益,可联系我们进行处理。