Brian Aker wrote:
Does anyone use the CASE operator? I see it for an SP, but in a SQL statement... seems like it we be bad practice (though I think the same of IF/ELSE in statements).
There are two CASE thingies in MySQL - the CASE expression which appears to follow SQL standard syntax and semantics and the CASE statement which does not, but is used only in stored procedures. The CASE expression shouldn't make applications less portable because it is pretty widely implemented, and generally implementations follow the standards syntax. Stored procedures and portability are another story. So my preference would be to keep at least the CASE expression. Best, Ann _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
