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

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

2025-03-04 15:34:32

推荐回答（2个）

回答1：

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：

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