Archive for the ‘Databases’ Category
MySQL Bubble Results Trick
I have discovered a cool MySQL trick that allows you to order a result set by a specified list - before ordering it by column X, Y or Z etc.
This is a slightly updated repost of an article I wrote on my old blog. I have had a few requests from people and one from birf to put it back up so here it is;
First, a lesson in the real implementation of cron…
The crontab command, found in Unix operating systems, is used to schedule [...]
I have discovered a cool MySQL trick that allows you to order a result set by a specified list - before ordering it by column X, Y or Z etc.
Copyright © 1984-2010 - James Crooke