select * from QunList361_370 where Class='369'and Title like 'ttt' union all select * from QunList361_370 where Class='369'and QunText like 'ttt'这句如何缩减
select * from QunList361_370 where Class='369'and Title like 'ttt' union all select * from QunList361_370 where Class='369'and QunText like 'ttt'这句如何缩减
select * from QunList361_370
where Class='369'and (Title like 'ttt' or QunText like 'ttt')这样也可以..
select * from QunList361_370
where Class='369'and (Title like 'ttt' or QunText like 'ttt')
FROM QunList361_370
WHERE Class = '369'
AND (Title LIKE '%ttt%'
or QunText LIKE '%ttt%')
FROM QunList361_370
WHERE Class = '369'
AND (Title LIKE '%ttt%'
or QunText LIKE '%ttt%')
select * from QunList361_370 where Class='369'and (Title='ttt' or QunText='ttt')
Where Class = '369' and (Title like 'ttt' or QunText like 'ttt')