SQL: Conditional Field output based on another field's value

Question

I have an interesting situation. my Table has a numeric field called "Discount". It's an integer. My table has another boolean field called "isPercent".

I would like to SELECT the discount field, let's assume the value is 50.

If isPercent is TRUE, I'd like to output it as "50%", else I'd like to output it cast to Money "$50".

How do I 'conditional select' this?

Jean-François Savard · Accepted Answer · 2015-02-24 23:09:53Z

1

You already have the boolean value stored. Simply do an if on it and concat the correct sign :

MySQL

select if(isPercent, concat(discount, '%'), concat('$', discount)) from ...

PostgreSQL

SELECT CASE 
  WHEN isPercent THEN discount || '%'
  ELSE '$' || discount END
FROM ...

edited Feb 24, 2015 at 23:09

answered Feb 24, 2015 at 23:03

Jean-François Savard

21k7 gold badges54 silver badges78 bronze badges

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

Collectives™ on Stack Overflow

SQL: Conditional Field output based on another field's value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related