Inline if-then-else in MySQL queries

Henning Koch

September 30, 2010Software engineer at makandra GmbH

It can be useful to have a Ruby expression like condition ? positive_case : negative_case in MySQL queries:

UPDATE users SET monthly_debit = IF(subscriber, 19, 0)

Illustration online protection

Rails professionals since 2007

Our laser focus on a single technology has made us a leader in this space. Need help?

We build a solid first version of your product
We train your development team
We rescue your project in trouble

Read more Show archive.org snapshot

License for source code

Posted by Henning Koch to makandra dev (2010-09-30 18:25)