Re: Can you do something like this in Mysql?

At 17:36 -0700 1/3/02, Mat Murdock wrote: >Can you do something like this in Mysql? The following lines are part of a >much larger sql query that we use on a MSsql box. MySQL has had CASE since earlier 3.23.x releases. > >... >case ar_open_items.doc_code >when 'I' t

Can you do something like this in Mysql?

Can you do something like this in Mysql? The following lines are part of a much larger sql query that we use on a MSsql box. ... case ar_open_items.doc_code when 'I' then 'Invoice' when 'C' then 'Credit Memo' when 'D' then 'Deb