How do you query PhpMyAdmin to remove WordPress comments in which the commenter added the website?
That's, comments by individuals who used a url: Title, Email, Website.
I wish to remove comments which have Website data.
try the folloing query, before place it for action, support your database first.
DELETE FROM wp_comments WHERE comment_author_url like '%http://%';
wp_comments table has got the fields
comment_content, amongst others.
Observe that before carrying out any database manipulation you need to back up your database, as these instructions if used incorrectly will remove all comments out of your blog.
If you wish to remove any comment in which the author placed an internet site within the comment_author_url area (which many do in order to identify their "home" blog,) this can be done:
delete from wp_comments where comment_author_url like '%http://%';
If rather you need to remove a comment in which the author placed an internet site within the content from the comment (out of the box normal with comment junk e-mail) that you can do
delete from wp_comments where comment_content like '%http://%';
Edit your question to possess more specifics by what for you to do if this doesn't answer your question.