Need UPDATE MySQL help with Pings (3 posts)

  1. Lorelle
    Posted 11 years ago #

    Somehow, probably when trying to turn off pings during my test phase, I have several hundred posts with blank in the ping_status field of my wp_posts table.

    I've tried different variations using the UPDATE command in MySQL, but I can't find "anything" when there is nothing to replace, since there is nothing there.

    Any ideas on how to search and replace these within the database so I don't have to go through and manually change them all?

    Here is one of the commands with "nothing" as the search that I tried:

    UPDATE wp_posts SET ping_status=open
    WHERE ping_status='';

  2. James Huff
    Support Representative
    Posted 11 years ago #

    Try this:

    UPDATE wp_posts SET ping_status="open";

  3. Lorelle
    Posted 11 years ago #

    macmanx, you are a STAR!!! I was sure I had to have a search string in there. THANK YOUOUOUOUOU!!! It replaced 216 in less than 4 seconds. Wow.

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.