select t1.*,t3.nickname sellername,t3.credit sellercredit
from product t1,userinfo t3
where (t1.sellerid=t3.ssn)
and (t3.state=0)
and (t1.name like :1 or t1.describe like :2)
and (t1.state=:3)
order by t1.starttime desc
还有一些更多条件限制的语句,不过我想主要原因是在like上.
from product t1,userinfo t3
where (t1.sellerid=t3.ssn)
and (t3.state=0)
and (t1.name like :1 or t1.describe like :2)
and (t1.state=:3)
order by t1.starttime desc
还有一些更多条件限制的语句,不过我想主要原因是在like上.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货