The CASE statement *is* supported in MySQL 4.0.x series (docs imply MySQL 5.0) Aug 12, 2004 • Kellan CASE is one of the coolest, most useful SQL constructs ever, more people should use it.