MySQL dynamic SELECT column value

Question

My MySQL table has these columns: Status : int(11) and Closed : int(1). The thing is that when I retrieve rows with SELECT, I want Closed to be treated as a Status value.

So, whenever Closed = 1, I want Status to be equal to -1. It's important to say that I need Status to be stored independently of the Closed column. Is that possible to do with the SELECT query or do I have to make like a PHP workaround for it ?

why can't you update the value of Status when Closed getting updated ? — Ravi
– Ravi, Commented Sep 30, 2017 at 12:22
Because, when the Closed value is updated back to 0, I need the previous Status value. That's why Status cannot be changed. — michalwa
– michalwa, Commented Sep 30, 2017 at 12:24

Ravi · Accepted Answer · 2017-09-30 12:26:27Z

7

You could use CASE statement

SELECT Closed,
CASE
    WHEN Closed = 1 THEN 
    -1
    ELSE Status
END AS Status
FROM <YOUR_TABLE>;

answered Sep 30, 2017 at 12:26

Ravi

31.6k44 gold badges124 silver badges180 bronze badges

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

1 Comment

michalwa Over a year ago

That's exactly what I wanted. Thank you so much.

Collectives™ on Stack Overflow

MySQL dynamic SELECT column value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related