mysql if elseif syntax condition

Question

If I have two parameter "parameterX" and "parameterY"

and I'll using "parameterX" and "parameterY" to commend sql snytax

like as

select * from test.test where 
IF(parameterY!=0)
 THEN test.test.'x'=parameterX AND test.test.'y'=parameterY 
ELSE IF
 test.test.'x'=parameterX 
END IF

I know this's can't work But I want to know have a other way like it and it can work in mysql

Oliv · Accepted Answer · 2016-04-22 05:57:59Z

1

Or easier (than @diehud's answer):

select * from test.test where 
test.test.'x'=parameterX AND (test.test.'y'=parameterY OR parameterY=0)

answered Apr 22, 2016 at 5:57

Oliv

10.9k4 gold badges60 silver badges78 bronze badges

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

Comments

dieuhd · Accepted Answer · 2016-04-22 04:57:08Z

1

I think dont need use IF ELSE syntax

select * from test.test where 
(parameterY!=0 and test.test.'x'=parameterX AND test.test.'y'=parameterY)
OR (parameterY = 0 and test.test.'x'=parameterX )

answered Apr 22, 2016 at 4:57

dieuhd

1,3261 gold badge10 silver badges22 bronze badges

Collectives™ on Stack Overflow

mysql if elseif syntax 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