{"id":2401,"date":"2012-10-15T22:01:54","date_gmt":"2012-10-16T02:01:54","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2012\/10\/15\/322-wordpress-comment-spam-query\/"},"modified":"2022-02-23T11:36:48","modified_gmt":"2022-02-23T16:36:48","slug":"wordpress-comment-spam-query","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/","title":{"rendered":"WordPress advanced comment spam clean up with query"},"content":{"rendered":"<p>In this article we\u2019ll discuss an even more advanced method for cleaning up spam comments from your WordPress database using phpMyAdmin.<\/p>\n<p>If you followed along with our <a href=\"\/support\/edu\/wordpress\/wordpress-comment-spam\/\">320: WordPress comment spam clean up<\/a> article this would be one of the more advanced methods mentioned in that article.<\/p>\n<p>The previous article <a href=\"\/support\/email\/wordpress-comment-spam-search\/\">321: WordPress advanced comment spam clean up with search<\/a> explained another advanced way of cleaning up spam from the database. The method discussed in this article can be used in conjunction with those steps in order to clean things up even better.<\/p>\n<h2>Multiple entry removal via advanced query<\/h2>\n<p>A lot of the time your spam comments are going to be mixed among good comments and hard to track down. You can use some advanced queries in phpMyAdmin to automate finding potential spam for removal using the steps below:<\/p>\n<ol class=\"article_list\">\n<li>First you\u2019ll need to <a href=\"\/support\/\">get to your WordPress database via the phpMyAdmin interface<\/a>.<\/li>\n<li>Click on the <strong>SQL<\/strong> tab at the top.<br><a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab.png\" rel=\"lightbox-0\"><img decoding=\"async\" width=\"532\" height=\"207\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab.png\" class=\"optimized-lcp-image\" alt=\"wp-comments-sql-tab\" loading=\"eager\" fetchpriority=\"high\" sizes=\"(max-width: 768px) 100vw, 768px\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab.png 532w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab-300x117.png 300w\"><\/a>\n<div style=\"clear:both;\"><\/div>\n<\/li>\n<li>Enter in the following query, then press <strong>Go<\/strong>.<br> \n<p>You\u2019ll want to adjust this query specific to your WordPress database and table prefix.<\/p>\n<p>In this example our database name is simply <strong>wordpress<\/strong>, and our table prefix is <strong>wp_<\/strong>.<\/p>\n<p>SELECT comment_author, COUNT(comment_author)<br>FROM wordpress.wp_comments<br> GROUP BY comment_author<br> HAVING COUNT(comment_author) &gt; 5<br> ORDER BY COUNT(comment_author)<br> DESC<\/p>\n<p> <a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-statement-and-go.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-statement-and-go\" class=\"std_ss\" height=\"379\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-statement-and-go.png\" width=\"424\"><\/a><\/p>\n<div style=\"clear:both;\"><\/div>\n<p>The SQL query breaks-down as follows:<\/p>\n<p><strong>SELECT comment_author, COUNT(comment_author)<\/strong><br> Selects the <strong>comment_author<\/strong> row and counts each entry.<\/p>\n<p><strong>FROM wordpress.wp_comments<\/strong><br> Sets the database and table we\u2019re selecting from.<\/p>\n<p><strong>GROUP BY comment_author<\/strong><br> Groups our selection by the <strong>comment_author<\/strong> row.<\/p>\n<p><strong>HAVING COUNT(comment_author) &gt; 5<\/strong><br> Only select entries that have 5 or more duplicate entries.<\/p>\n<p><strong>ORDER BY COUNT(comment_author)<\/strong><br>Order the results by the number of duplicate entries.<\/p>\n<p><strong>DESC<\/strong><br> Sort our entries descending, showing largest entries first.<\/p>\n<p>\u00a0<\/p>\n<\/li>\n<li>Copy <strong>(Ctrl-C)<\/strong> the text of the <strong>comment_author<\/strong> entry with the most duplicate entries. <a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-results\" class=\"std_ss\" height=\"853\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results.png\" width=\"398\"><\/a>\n<div style=\"clear:both;\"><\/div>\n<\/li>\n<li>Click on the <strong>Search<\/strong> tab.<br><a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-results-search\" class=\"std_ss\" height=\"544\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search.png\" width=\"349\"><\/a>\n<div style=\"clear:both;\"><\/div>\n<\/li>\n<li>In the first field <strong>Word(s) or value(s) to search for:<\/strong> paste <strong>(Ctrl-v)<\/strong> your copied text.\n<p> Place <strong>%<\/strong> symbols in-front and behind of the text for wildcards, now any entry containing the word at all will display.<\/p>\n<p> Leave the <strong>Find:<\/strong> option as the default of at <strong>least one of the words<\/strong>.<\/p>\n<p> In the <strong>Inside table(s):<\/strong> menu click on <strong>wp_comments<\/strong> to only search within that table.<\/p>\n<p> Next to the <strong>Inside column:<\/strong> field enter in <strong>comment_author<\/strong>, then finally click <strong>Go<\/strong>.<a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-go.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-results-search-go\" class=\"std_ss\" height=\"549\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-go.png\" width=\"412\"><\/a><\/p>\n<div style=\"clear:both;\"><\/div>\n<\/li>\n<li>Click on <strong>Browse<\/strong>.<br><a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-browse.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-results-search-browse\" class=\"std_ss\" height=\"194\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-browse.png\" width=\"357\"><\/a>\n<div style=\"clear:both;\"><\/div>\n<\/li>\n<li>Now you can review the <strong>comment_content<\/strong> row for that user to determine if it\u2019s all spam content.<br><a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-comments-content.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-results-search-comments-content\" class=\"std_ss\" height=\"865\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-comments-content.png\" width=\"1445\"><\/a>\n<div style=\"clear:both;\"><\/div>\n<\/li>\n<li>In this case all comments were spam, so scroll to the bottom and click on <strong>Check All<\/strong>.\n<p> If not all of the comments were spam, you can simply place a checkmark beside the ones that you wish to remove.<br><a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-check-all.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-results-search-check-all\" class=\"std_ss\" height=\"322\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-check-all.png\" width=\"1446\"><\/a><\/p>\n<div style=\"clear:both;\"><\/div>\n<\/li>\n<li>Then click on <strong>Delete<\/strong> at the bottom of the page.\u00a0<a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-delete.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-results-search-delete\" class=\"std_ss\" height=\"328\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-delete.png\" width=\"1443\"><\/a>\n<div style=\"clear:both;\"><\/div>\n<\/li>\n<li>Confirm your deletions by clicking on <strong>Yes<\/strong>.<br><a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-delete-confirm.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-results-search-delete-confirm\" class=\"std_ss\" height=\"564\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-delete-confirm.png\" width=\"595\"><\/a>\n<div style=\"clear:both;\"><\/div>\n<\/li>\n<li>MySQL should now return an empty result set if the deletion was successful.\u00a0<a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-delete-empty.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-results-search-delete-empty\" class=\"std_ss\" height=\"245\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-results-search-delete-empty.png\" width=\"491\"><\/a>\n<div style=\"clear:both;\"><\/div>\n<p> Below you can see why this can be such an efficient method for finding spam in your WordPress database, using the different common WordPress comment rows we can find duplicate entries easily: <\/p>\n<div style=\"width: 33%; float: left;\">\n<p><strong>comment_post_ID<\/strong><\/p>\n<p> <a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-comment-post-ID.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-comment-post-ID\" class=\"std_ss\" height=\"616\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-comment-post-ID.png\" width=\"340\"><\/a><\/p>\n<div style=\"clear:both;\"><\/div>\n<\/div>\n<div style=\"width: 33%; float: left;\">\n<p><strong>comment_author<\/strong><\/p>\n<p> <a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-comment-author.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-comment-author\" class=\"std_ss\" height=\"653\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-comment-author.png\" width=\"317\"><\/a><\/p>\n<div style=\"clear:both;\"><\/div>\n<\/div>\n<div style=\"width: 33%; float: right;\">\n<p><strong>comment_author_email<\/strong><\/p>\n<p> <a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-comment-author-email.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-comment-author-email\" class=\"std_ss\" height=\"588\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-comment-author-email.png\" width=\"417\"><\/a><\/p>\n<div style=\"clear:both;\"><\/div>\n<\/div>\n<div style=\"clear: both;\">\u00a0<\/div>\n<div style=\"width: 33%; float: left;\">\n<p><strong>comment_author_url<\/strong><\/p>\n<p> <a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-comment-author-url.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-comment-author-url\" class=\"std_ss\" height=\"556\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-comment-author-url.png\" style=\"width: 116px;\" width=\"445\"><\/a><\/p>\n<div style=\"clear:both;\"><\/div>\n<\/div>\n<div style=\"width: 33%; float: left;\">\n<p><strong>comment_author_IP<\/strong><\/p>\n<p> <a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-comment-author-IP.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-comment-author-IP\" class=\"std_ss\" height=\"572\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-comment-author-IP.png\" width=\"350\"><\/a><\/p>\n<div style=\"clear:both;\"><\/div>\n<\/div>\n<div style=\"width: 33%; float: right;\">\n<p><strong>comment_content<\/strong><\/p>\n<p> <a href=\"\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-comment-content.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"wp-comments-sql-comment-content\" class=\"std_ss\" height=\"549\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-comment-content.png\" style=\"width: 116px;\" width=\"470\"><\/a><\/p>\n<div style=\"clear:both;\"><\/div>\n<\/div>\n<div style=\"clear: both;\">\u00a0<\/div>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>In this article we\u2019ll discuss an even more advanced method for cleaning up spam comments from your WordPress database using phpMyAdmin. If you followed along with our 320: WordPress comment spam clean up article this would be one of the more advanced methods mentioned in that article. The previous article 321: WordPress advanced comment spam<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/\"> Read More ><\/a><\/p>\n","protected":false},"author":57014,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[56],"tags":[],"class_list":["post-2401","post","type-post","status-publish","format-standard","hentry","category-wordpress"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>WordPress advanced comment spam clean up with query | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"In this article we&#039;ll explain  how to use phpMyAdmin&#039;s advanced query functionality to help clean up WordPress comment spam from the database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"WordPress advanced comment spam clean up with query | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"In this article we&#039;ll explain  how to use phpMyAdmin&#039;s advanced query functionality to help clean up WordPress comment spam from the database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-10-16T02:01:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-23T16:36:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab.png\" \/>\n<meta name=\"author\" content=\"InMotion Hosting Contributor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InMotion Hosting Contributor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\"},\"headline\":\"WordPress advanced comment spam clean up with query\",\"datePublished\":\"2012-10-16T02:01:54+00:00\",\"dateModified\":\"2022-02-23T16:36:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/\"},\"wordCount\":552,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab.png\",\"articleSection\":[\"WordPress Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/\",\"name\":\"WordPress advanced comment spam clean up with query | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab.png\",\"datePublished\":\"2012-10-16T02:01:54+00:00\",\"dateModified\":\"2022-02-23T16:36:48+00:00\",\"description\":\"In this article we'll explain how to use phpMyAdmin's advanced query functionality to help clean up WordPress comment spam from the database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab.png\",\"width\":532,\"height\":207,\"caption\":\"wp-comments-sql-tab\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WordPress advanced comment spam clean up with query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\",\"name\":\"InMotion Hosting Contributor\",\"description\":\"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/inmotion-hosting\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"WordPress advanced comment spam clean up with query | InMotion Hosting","description":"In this article we'll explain  how to use phpMyAdmin's advanced query functionality to help clean up WordPress comment spam from the database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/","og_locale":"en_US","og_type":"article","og_title":"WordPress advanced comment spam clean up with query | InMotion Hosting","og_description":"In this article we'll explain  how to use phpMyAdmin's advanced query functionality to help clean up WordPress comment spam from the database.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2012-10-16T02:01:54+00:00","article_modified_time":"2022-02-23T16:36:48+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab.png","type":"","width":"","height":""}],"author":"InMotion Hosting Contributor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"InMotion Hosting Contributor","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644"},"headline":"WordPress advanced comment spam clean up with query","datePublished":"2012-10-16T02:01:54+00:00","dateModified":"2022-02-23T16:36:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/"},"wordCount":552,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab.png","articleSection":["WordPress Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/","name":"WordPress advanced comment spam clean up with query | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab.png","datePublished":"2012-10-16T02:01:54+00:00","dateModified":"2022-02-23T16:36:48+00:00","description":"In this article we'll explain how to use phpMyAdmin's advanced query functionality to help clean up WordPress comment spam from the database.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/phpMyAdmin_wordpress-spam_wp-comments-sql-tab.png","width":532,"height":207,"caption":"wp-comments-sql-tab"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"WordPress advanced comment spam clean up with query"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644","name":"InMotion Hosting Contributor","description":"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!","sameAs":["https:\/\/www.linkedin.com\/company\/inmotion-hosting\/","https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/57014"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=2401"}],"version-history":[{"count":3,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2401\/revisions"}],"predecessor-version":[{"id":85505,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2401\/revisions\/85505"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=2401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=2401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=2401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}