WordPress is a very popular tool for building a website, almost one in 6 sites in the world is designed with this CMS. It is so popular that it makes SEOs wanting to get a link in the comments of the articles easily. Links to improve the SEO of a website on Google.
This popularity with SEOs, pushes many Internet users to post comments with the name “Name @ Keyword” to respect the format used by the KeywordLuv plugin. Admittedly, it doesn’t look like a real username. This article will present an SQL query to remove the keywords from names and thus avoid ending up with names such as: “Paul @ serrurier Paris”, “Maurice @ mutual health”, “Sophie @ coque iPhone”…
It is therefore possible to automatically delete the keywords contained in the name of the commentator by using the following SQL query:
UPDATE `wp_comments` SET `comment_author` = SUBSTRING(`comment_author`, 1, LOCATE("@", `comment_author`) - 1) WHERE `comment_author` LIKE "%@%"
This SQL query uses the LOCATE () and SUBSTRING () functions. Depending on your Database Management System (DBMS), the query may be adapted (because some DBMS use for example the SUBSTR () or INSTR () function).
It is possible to automate the execution of this request by placing it in a CRON request. This makes it possible to accept comments automatically, without accepting optimized links from the people who write them.