请教大师们,SQL语句多个or之后,如何继续用and筛选条件?

select * from dbo.tb_AddressList where add_Name like'%西安%' or add_Address like'%西安%' and add_Typeid=1

后面的 add_typeid=几就不管用了,怎么才能让他管用呢

举报该文章

其他看法

第1个回答 2010-03-26

select * from dbo.tb_AddressList where (add_Name like'%西安%' or add_Address like'%西安%') and add_Typeid=1

select * from dbo.tb_AddressList where add_Name like'%西安%' and add_Typeid=1
union
select * from dbo.tb_AddressList where add_Address like'%西安%' and add_Typeid=1本回答被提问者采纳

第2个回答 2010-03-26

select * from dbo.tb_AddressList where (add_Name like'%西安%' or add_Address like'%西安%') and add_Typeid=1

相似回答

sql语句中的and 和or能有多个吗?另外如果语句sql语句中只能有一个and的...答：SQL中可以以多个AND或OR，当条件混乱时，可以使用括号。如a and (b or c)这样的。楼主补充的语句可以修改为 sql="select top 16 * from tb_goods where id not in (select top "+(nowPage*16)+" id from tb_goods where classes='"+classes2+"' and price<=500 order by id asc)and...