34,838
社区成员




--上面的有问题,这个好像没问题了
select * from message
where ' '+(title+' '+content)+' '
like '%cement%opc%clinker%'
and ' '+(title+' '+content)+' '
not like '%[A-z]cement%opc%clinker%'
and ' '+(title+' '+content)+' '
not like '%cement[A-z]%opc%clinker%'
and ' '+(title+' '+content)+' '
not like '%cement%[A-z]opc%clinker%'
and ' '+(title+' '+content)+' '
not like '%cement%opc[A-z]%clinker%'
and ' '+(title+' '+content)+' '
not like '%cement%opc%clinker[A-z]%'
--and ' '+(title+' '+content)+' ' not like '%cement%opc%[A-z]clinker%' --这个原来好像没要求
select * from message
where ' '+(title+' '+content)+' '
like '%[^A-z]cement[^A-z]%[^A-z]opc[^A-z]%clinker[^A-z]%'
or ' '+(title+' '+content)+' '
like 'cement[^A-z]%[^A-z]opc[^A-z]%clinker[^A-z]%'
or ' '+(title+' '+content)+' '
like 'cement[^A-z]%[^A-z]opc[^A-z]%clinker'
or ' '+(title+' '+content)+' '
like '%[^A-z]cement[^A-z]%[^A-z]opc[^A-z]%clinker'