Chris Komlenic - komlenic.com

Something I've rarely needed to use, but recently rediscovered is using nested inline MySQL IF statements in select queries to conditionally assign a value. If that doesn't make sense, read on. It's pretty simple.
The Basic "IF"
IF functions in MySQL (when used inline, as opposed to IF in a stored procedure) are nothing more than ternary statements. They take three parts and have a very simple syntax:...

MySQL's ENUM data-type is a hot spot that sometimes generates strong opinions among developers. At first glance it seems like an efficient solution for declaring a set of permitted values from which only one can be chosen for each record. A good example...

If Google is any indication, I'm not the only developer who has spent hours trying to understand how to best integrate CKEditor to handle code snippets, problematic entities and pre-formatted text . Wrap your code snippet in a <pre> or <code...

There are no new ideas. There are only new ways of making them felt. - Audre Lorde
I've spent a significant portion of my life thinking that someday, I'd have some great idea that would bring me some combination of fame, fortune, or fulfillment. That there was some truly great as-yet-un-thought thing that could stand on its own for...