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 )