Special Content

Home Science, Programming and Technology WordPress SQL / Wordpress - query for removing a comment field

SQL / WordPress – query for removing a comment field

February 13, 20235 Views

Does anyone know how can I replace the “comment_author_url” field from all comments by running a SQL query?

for example if this field is http://google.com to replace it with "" (empty string)

Post Views: 5

1 comment

Use:

UPDATE your_table
   SET comment_author_url = ''
 WHERE comment_author_url = 'http://google.com'