比如说现在有3个条件iapplystatus = 3
strapplyername = 某某
strtitle = 333;我在数据库里怎么同时查找3个啊。。我是新手,谁路过帮个忙呗select * from ybdeviceapplyform where iapplystatus = 3 and strapplyername = '某某' and strtitle = 333;这样吗?
strapplyername = 某某
strtitle = 333;我在数据库里怎么同时查找3个啊。。我是新手,谁路过帮个忙呗select * from ybdeviceapplyform where iapplystatus = 3 and strapplyername = '某某' and strtitle = 333;这样吗?
如果是要同时满足三个条件就用and
如果是满足其中一个就可以 就用or
select count(*)
from ybdeviceapplyform
where iapplystatus = 3
and strapplyername = '某某'
and strtitle = 333;
-- or 意思是:或者-- 逻辑运算:与、或、非,相对大家来说,应该很清楚!