Category: sql

First of it all, login to your phpmyadmin and choose your WordPress database. Once done, click on the sql button to open the sql command window. Then, simply paste the following sql command and execute it. DELETE FROM `wp_options` WHERE `option_name` LIKE (‘%_transient_%’); Credit: Stack Overflow Want more super useful SQL queries? Check out this […]

Rating

Just run the following query on your WordPress database to delete comments with nastyspamurl as url. Don’t forget to replace the table prefix wp_ if your database is using another prefix.And of course, create a backup of your database before running the query! DELETE from wp_comments WHERE comment_author_url LIKE “%nastyspamurl%” ; The post WordPress tip: […]

Rating