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