SQL Statement help re categories

  • The situation is as follows:-

    I’ve recategorised my content which (for example) was like:-

    – Local News
    – International News

    Into more granular categories like:-

    – News
    — Local News
    — International News

    The only problem is of course that existing posts/content have category tags of (for example) “Local News” but are not currently also tagged into the parent category of “News” because of course it didn’t exist when the post was written.

    Rather than going through my posts manually I’m assuming a smart SQL statement of some description against the appropriate WP database table would enable me to take all posts with the sub-categories and also tag them with the new parent.

    Is this the smart/best way to do it?

    Also – if so – what is the sql statement syntax that I would need to run against which table?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter c0y0te

    (@c0y0te)

    I’ve come across a plugin (Batch Category Edit) which goes some way towards helping this situation, but it’s not perfect. I’d much prefer to just blitz the DB with some sql statements if possible rather than navigating through the screen by screen plugin version.

    SQL genius required? ??

    Thread Starter c0y0te

    (@c0y0te)

    I’d really love to get my site sorted before the weekend (I want to migrate it to a new hoster with the new categories structure sorted before I export the data)…

    Can some kind soul with SQL lend me a hand and tell me the syntax to do this please? Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘SQL Statement help re categories’ is closed to new replies.