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 )
执行成功图供参考,另外搞之前先备份数据库有风险
声明：本站所有软件资源版权均属于原作者所有，这里所提供资源均只能用于参考学习用，请勿直接商用。若由于商用引起版权纠纷，一切责任均由使用者承担。