Clear all urls in comments table

  • Resolved salave

    (@salave)


    1 year, 4 months ago

    Hello, i’m searching for someone to help us create a SQL query that will be executed across our database and clear every detail in the row of URLS inside the Comment Table.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter salave

    (@salave)

    The urls am trying to talk about are the ones which are attached on profiles as backlinks.

    Moderator bcworkz

    (@bcworkz)

    UPDATE 'wp_comments' SET 'comment_author_url'='' WHERE 1=1 LIMIT 2;
    Execute from the SQL tab for the DB in phpMyAdmin app. I placed a limit clause so you can first confirm this works and does what you want. Remove LIMIT 2 to clear the entire table’s column.

    I recommend making a backup of the table prior to executing any major change like this.

    Thread Starter salave

    (@salave)

    ? 603 rows affected. (Query took 0.4229 seconds.)

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Clear all urls in comments table’ is closed to new replies.