mysql query with if else statements

Question

I have following fields in my ad_table table:

+----------------------------------------------------------+
|ADVT_ID | RELATIVE_ID | AD_TYPE | AD_LOCATION | AD_IMAGE  |
+----------------------------------------------------------+
|1       | 2            |  FP    | H           | test1.jpg |
|2       | 0            |  FP    | H           | test2.jpg |
|3       | 0            |  TB    | H           | test3.jpg |
+----------------------------------------------------------+

I want to use two if statements in mysql query. I want to retrieve data from table using mysql query in this format:

FIRST IF STATEMENT :

if (AD_TYPE = 'FP' && AD_LOCATION = 'H')
then select all data from
table where RELATIVE_ID !=0

SECOND IF STATEMENT :

if(AD_TYPE != 'FP' && AD_LOCATION != 'H')
then select all data from
table where RELATIVE_ID =0

So how to do that in mysql query?

Why do this in mysql? Use php to process which query you will call. You should always limit the number of calls to the MYSQL servers and offload as much processing on the application (php) side. Of course, you might not be able to do that... but this is the ideal setup. — ProfileTwist
– ProfileTwist, Commented Apr 28, 2014 at 8:06
Are you talking about the IF flow control statement or the IF() function? The first one is only available in procedures and functions and you don't mention you're writing one. The function, of course, is not a flow control structure. Also, what does the PHP tag have to do with your question? — Álvaro González
– Álvaro González, Commented Apr 28, 2014 at 8:10

P. Camilleri · Accepted Answer · 2014-04-28 07:45:34Z

4

You can try:

SELECT *
FROM ad_table
WHERE (AD_TYPE = 'FP' AND AD_LOCATION = 'H' AND RELATIVE_ID !=0)
   OR (AD_TYPE != 'FP' AND AD_LOCATION != 'H' AND RELATIVE_ID =0)

answered Apr 28, 2014 at 7:45

P. Camilleri

13.3k10 gold badges49 silver badges85 bronze badges

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

8 Comments

s4suryapal Over a year ago

i want to do something like that if(AD_TYPE = 'FP' AND AD_LOCATION = 'H') then select all data where RELATIVE_ID !=0 if(AD_TYPE != 'FP' AND AD_LOCATION != 'H') then select all data where RELATIVE_ID =0

P. Camilleri Over a year ago

"if(AD_TYPE = 'FP' AND AD_LOCATION = 'H')", but for which line ? These values are not constant over your table.

s4suryapal Over a year ago

i want to use two if statements in mysql query

s4suryapal Over a year ago

First IF :if(AD_TYPE = 'FP' AND AD_LOCATION = 'H') then select all data where RELATIVE_ID !=0 SECOND IF :if(AD_TYPE != 'FP' AND AD_LOCATION != 'H') then select all data where RELATIVE_ID =0

P. Camilleri Over a year ago

You don't understand.

|

Collectives™ on Stack Overflow

mysql query with if else statements

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related