CASE Statements with MySQL yet?

[rlawson]

I use CASE statements all the time in MS SQL. I want to make my code portable with MySQL if possible. I could not find any info on mysql.org. Are CASE statements available or planned for MySQL? Does anyone know?

(This is not case sensitivity)

Ron

[toma42]

Dunno if it's the same, but mysql case is documented here:

http://www.mysql.com/doc/en/Control_flow_functions.html

Note that CASE is not sql92 and should not be used if you're createing a cross-database application.

[rlawson]

That's what I needed.

I wrote some custom functions to handle all DB conenctions, closing, queries, etc... and I have tried to keep everything nearly completely portable.

We run Linux and IIS on several servers and if we ever migrate one site to another, I want it to work nearly flawlessly.

Thanks again.

Ron