关于WHERE后面能不能加IF判断的？

[fenghua_518]

关于WHERE后面能不能加IF判断的
select * from table1
where
(if 1>0 table1.id001>1 else table1.id001>1 end)
上述为何有误？请高手指点

[子陌红尘]

select *
from table1
where (case when 1>0 then table1.id001 else table1.id001 end)>1

[-狙击手-]

case

[子陌红尘]

select
*
from
table1
where
(case
when 1>0 and table1.id001>1
then 1
when table1.id001>1
then 1
else 0
end)=1