I just want to share a simple MySQL snippet to batch update product type in Magento. This is a pretty basic SQL query, and I’ll just save it here in my blog so that I can remember what I did to update product types by batch. I just went to my SQL database via phpmyadmin,… Continue reading Magento Batch Update Product Type in MySQL
Tag: MySQL
Delete WordPress Comments based on IP Range
First of all. Happy new year everyone! This is my first post for the year 2014, and I would like to share a useful MySQL snippet wherein you can delete a series of comments based from an author’s IP. We all know for a fact that akismet can’t block all spam comments. My blog itself… Continue reading Delete WordPress Comments based on IP Range