select * from (select Title from Info News where Title like '%str%') t
where Title like '%newstr%' or Introduce Like '%newstr%'
where Title like '%newstr%' or Introduce Like '%newstr%'
调试欢乐多
select * form News
where Total like '%newstr%' or Introduce like '%newstr%'
where (Title In (select Title from Info News) and
(Introduce In (select Introduce from Info News)) and
(Title like '%newstr%'or Introduce Like '%newstr%'))
or (Introduce Like '%newstr%' and Introduce In(select Introduce from Info News where Introduce like '%str%') )
例如google个人认为应该用in or not in
我是想得到这样的效果
下面是错误的sql 语句 ,但大家应该看的懂咯select * from News where Title,Introduce In (select Title,Introduce from Info News where Title like '%str%' or Introduce like '%str%') and Title like '%newstr%'or Introduce Like '%newstr%'
select News.*
from (select Title,Introduce from Info News where Title like '%str%') t,
Info News
where News.Title=t.Title and News.Introduce=t.Introduce
and News.Title like '%newstr%' or News.Introduce Like '%newstr%'