MySQL Query - SELECT based on condition

Question

I cannot find an answer to this seemingly easy problem. I need to execute a different SELECT statement based on a condition.

A simple example :

if <condition>

SELECT id FROM table;

otherwise

SELECT id FROM table WHERE variable=1;

In other words I need to add an additional WHERE clause depending on the condition, however the problem boils down to choosing a different SELECT clause based on whether the condition is true or false.

could you please put the example of condition? It would be better then ofcourse. — Suraj Kumar
– Suraj Kumar, Commented Aug 13, 2014 at 19:17

Menno · Accepted Answer · 2014-08-13 18:32:33Z

1

SELECT id FROM table WHERE variable=1 OR <condition>

answered Aug 13, 2014 at 18:32

Menno

12.8k14 gold badges59 silver badges92 bronze badges

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

Comments

Twelfth · Accepted Answer · 2014-08-13 18:45:39Z

0

case statements can be used as well...

SELECT id FROM table
where case when variable is not null then variable else 1 end
=
case when variable is not null then @variable else 1 end

You'll probably want different logic in the case statements, but this is saying when variable has a value (not null) then use the where clause variable = @variable, else 1=1 (which brings back all rows / no filter).

answered Aug 13, 2014 at 18:45

Twelfth

7,2083 gold badges30 silver badges35 bronze badges

Collectives™ on Stack Overflow

MySQL Query - SELECT based on condition

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