categories - Change the category of all posts in it

I'm trying to make a category change of some posts by MySQL.

But I am not able to give the update in the database, it is giving error when running the query.

UPDATE *
FROM mooca_posts
LEFT JOIN mooca_term_relationships ON (mooca_posts.ID = mooca_term_relationships.object_id)
LEFT JOIN mooca_term_taxonomy ON (mooca_term_relationships.term_taxonomy_id = mooca_term_taxonomy.term_taxonomy_id)
SET mooca_term_taxonomy.term_id = '112'
WHERE mooca_term_taxonomy.term_id IN (1448)
GROUP BY mooca_posts.ID

I need to change from category 1448 to 112.

I'm trying to make a category change of some posts by MySQL.

But I am not able to give the update in the database, it is giving error when running the query.

UPDATE *
FROM mooca_posts
LEFT JOIN mooca_term_relationships ON (mooca_posts.ID = mooca_term_relationships.object_id)
LEFT JOIN mooca_term_taxonomy ON (mooca_term_relationships.term_taxonomy_id = mooca_term_taxonomy.term_taxonomy_id)
SET mooca_term_taxonomy.term_id = '112'
WHERE mooca_term_taxonomy.term_id IN (1448)
GROUP BY mooca_posts.ID

I need to change from category 1448 to 112.

• categories
• mysql

Share Improve this question edited Feb 4, 2019 at 14:45 Sven 3,68411 gold badge3636 silver badges4848 bronze badges asked Feb 4, 2019 at 12:04 Marcelo TomazMarcelo Tomaz 1533 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

UPDATE wp_term_relationships 
  SET term_taxonomy_id = 112
WHERE term_taxonomy_id = 1448

Try this