Tag: MySQL

Magento Batch Update Product Type in MySQL

Sep 8, 2017

—

by

Bryan Veloso

in Geekery

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,…
Delete WordPress Comments based on IP Range

Jan 3, 2014

—

by

Bryan Veloso

in Geekery, Internet

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…