SQL question

  • Resolved mtmquotesearch

    (@mtmquotesearch)


    11 years, 9 months ago

    I’m trying to update a lot of blog posts’ status at the same time. I found a command:

    UPDATE wp_posts SET post_status=’STATUS’;

    but I have no idea how to actually use this command. Can someone help?

    How do I access the SQL and how do i run this command?

    If there is a link somewhere that i could just read, please post it.

    Thanks so much!

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

    (@mtmquotesearch)

    I figured out how to do it – but when i did so it actually deleted all my posts!

    clearly it’s wrong. what should the SQL command be?

    Thread Starter mtmquotesearch

    (@mtmquotesearch)

    I figured it out.

    The other thread said to change it to PUBLIC, which was wrong. It should be PUBLISH

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

Tags