using conditional statement in WHERE clause mysql

Question

If keep_base_amount is null then I want to use country_id=236 in where clause, else I want to use keep_base_amount's value as in country_id.

I have query something like this:

SELECT * FROM account_treasury_local
WHERE
CASE WHEN keep_base_amount IS NOT NULL THEN country_id = keep_base_amount
ELSE country_id = '236' END

There is a record in database. But, I am getting nothing in result. Is there anything missing/wrong in above query.

what is the record in your DB? because this should work but I'd prefer to use AND|OR for this and not CASE clause — gabor.harsanyi
– gabor.harsanyi, Commented Feb 24, 2015 at 21:33

Pinx0 · Accepted Answer · 2015-02-24 21:32:59Z

3

As simple as this

SELECT * FROM account_treasury_local
WHERE (keep_base_amount IS NOT NULL AND country_id = keep_base_amount) OR (keep_base_amount IS NULL AND country_id = '236')

answered Feb 24, 2015 at 21:32

Pinx0

1,25818 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Blah Argh · Accepted Answer · 2015-02-24 21:34:22Z

1

Have you tried:

SELECT * FROM account_treasury_local
WHERE
  (keep_base_amount IS NOT NULL AND country_id = keep_base_amount)
  OR
  (keep_base_amount IS NULL AND country_id = '236')

I'm not sure I'm understanding your question correctly.

answered Feb 24, 2015 at 21:34

Blah Argh

3021 silver badge4 bronze badges

Collectives™ on Stack Overflow

using conditional statement in WHERE clause mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related