Question

ASP数据库怎样两个条件查询

要怎么写才能查询同时满足两个条件？

Answer 1

这要看你是模糊查询还是精确查询模糊查询的方法:select * from news where 字段1 like '%关键字%' and 字段2 like '%关键字%' 精确查询的方法:select * from news where 字段1=xxx and 字段2=xxxx

Answer 2

select * from table where 字段1=xxx and 字段2=xxxx

Answer 3

select * from 字段名1 and 字段名2

Answer 4

用and