mysql的条件语句_mysql条件语句

AND((c.shouli_sj>1288945672ANDc.diaochaqingkuangISNULL)or(c.shouli_sj<1288945672ANDc.diaochaqingkuangISNULL)or(c.diaochaqingkuang!=''))这块有问题该怎么改?SELECTc.*,u.name...

AND ((c.shouli_sj >1288945672AND c.diaochaqingkuang IS NULL) or ( c.shouli_sj<1288945672AND c.diaochaqingkuang IS NULL ) or (c.diaochaqingkuang != '' ))

这块有问题该怎么改?

SELECT c . * , u.name AS terminal_name, r.region_name, ur.region_name AS area_name

FROM complain c

LEFT JOIN user u ON u.id = c.shouliren

LEFT JOIN region r ON r.region_id = u.region_id

LEFT JOIN region ur ON r.parent_id = ur.region_id

WHERE 1 =1

AND c.chulibumen

IN ( 1, 2 )

AND (

(

c.shouli_sj >1288945672

AND c.diaochaqingkuang IS NULL

) or ( c.shouli_sj <1288945672

AND c.diaochaqingkuang IS NULL ) or ( c.diaochaqingkuang != '' )

)

AND c.to_time >= '1277942400'

AND c.to_time <= '1289001599'

ORDER BY c.shouli_sj DESC

LIMIT 0 , 30

我的意思是说包含上面那个语句的下面那一大段出错了，具体是什么错误我找不到，请大家帮忙，感谢！

这段东西不报错,就是查不出东西,数据库里确实有东西

这样能查出来

AND ((c.diaochaqingkuang != '' ))

加了or后变成下面那样就没有数据了

AND ((c.shouli_sj >1288945672 AND c.diaochaqingkuang IS NULL) or ( c.shouli_sj<1288945672 AND c.diaochaqingkuang IS NULL ) or (c.diaochaqingkuang != '' ))

展开