Presenting alternate fields based on a condition

Question

I want to present 4 fields from a table but the 4th field is based on a condition.

i.e. I want to present field1, field2, field3 and then either field4 or field5 where the choice of field5 would be based on a condition.

Is this possible?

I can present the table of field1, field2, field3 and field4 with no problem.

Do you want to encode the condition into the SQL or into the php code? Both are capable of handling that. It might also be helpful to edit the question to include a minimal reproducible example. — Jason Aller
– Jason Aller, Commented Aug 4, 2019 at 19:45

Tim Biegeleisen · Accepted Answer · 2019-08-04 02:01:21Z

0

Use a CASE expression:

SELECT
    field1,
    field2,
    field3,
    CASE WHEN <some condition> THEN field4 ELSE field5 END AS other_field
FROM yourTable;

Or, you could use MySQL's IF function:

IF(<some condition>, field4, field) AS other_field

answered Aug 4, 2019 at 2:01

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

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

3 Comments

Mike Smith Over a year ago

Yes, the IF statement worked fine. Thank you very much.

Mike Smith Over a year ago

The answer has helped me very much. It says I am supposed to click on a green check mark to the right. There is no green check mark anywhere on my screen, so I am sending this note to accept the answer and to close the thread.

Mike Smith Over a year ago

Yes, I think I got it to work, the check mark is showing now and it is showing green. Thanks again.

Collectives™ on Stack Overflow

Presenting alternate fields based on a condition

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related