Web Development, Networking, Security, SEO
Those who've stumbled upon this post are probably looking for a way to perform a LIKE statement on a numeric value column in a MySQL, MariaDB or SQL Server Database. …
LIKE operator equivalent for integer / numeric value Columns in a SQL (or T-SQL) Database Read More
If you've stumbled upon this post it probably means that you're trying to normalize the Collation of your Database(s), Table(s) and/or Column(s) to avoid hitting illegal mix type errors such …
MySQL - How to find all Table Columns in all Databases with a given Collation Name - Character Set Name Read More
A few months ago I wrote an article explaining how to convert all MySQL tables belonging to one or more Database(s) from MyISAM to InnoDB and vice-versa with a simple, yet …
MySQL - How to convert all Database Tables and Columns to a specific Collation Read More Today I had to fix a nasty issue in one of my PHP-based websites: to put it into few words, I needed to find a way to trasform a number …
MySQL function (and query) to convert a string into a slug for readable URL permalinks Read More
Those who are frequently working with Worpress often find themselves operating mass-replace tasks throughout the whole WP Database. Such situation most likely arises in the following scenarios: WebSite URL change …
WordPress - How to perform Search and Replace on whole Database (post, pages, wp_options) using WP plugins or MySQL tools Read More Today a client asked me to remove all the posts from a given category to the auto-generated XML Sitemap of his WordPress blog and also redirect these posts to a …
WordPress - How to retrieve all posts from one or more given categories with a SQL query Read More
If you found this post you most certainly know Mantis BugTracker, also known as MantisBT, the award-winner open-source bug tracking platform built with PHP and MySQL. If you use it …
Mantis BugTracker - How to change a bug date and time (with all related notes, history and info) with a bunch MySQL scripts Read More Yesterday I was trying to investigate through an odd size increment affecting one of our MySQL databases. Since I didn't knew about the table(s) affected by the issue, the first …
How to get the size of all MySQL Tables in all Databases (and other size-related queries) Read More
If you're working a lot with MySQL you're most certainly aware of MySQL Workbench, the official administration & management framework for MySQL DBAs and operators: that suite comes shipped with a …
SQLyog - The best freeware MySQL Administration GUI for Windows Read More Have you ever needed to convert one, some or all the tables of a MySQL Database from MyISAM to InnoDB or the other way around? Here's a couple queries you …
MySQL - Convert all Tables of one or more Database(s) from MyISAM to InnoDB and vice-versa Read More