Conditional evaluation in where clause

ominobufo · #1 (**permalink**) 12-29-05, 08:35

Hi everybody

I use this expression in my where clause

Code:

((isnull(<value>)) or (colname = <value>))

if I set <value> to NULL the condition is skipped

If I set the <value> to some real value it is evaluated

i am in need of something similar for the IN statement, in that case <value> becomes <values list> but then

Code:

((isnull(<values list>)) or (colname in <values list>))

if <values list> is null the condition is skipped otherwise i get an error because

isnull((2,3,4)) is not accepted by mysql

any suggestion to make this work?

jfulton · #2 (**permalink**) 01-03-06, 10:10

I think if you use the COALESCE function in your ISNULL statement, you may get what you are looking for.

Internet Services

Web Development

Digital Marketing

Consumer Tech