34,588
社区成员
发帖
与我相关
我的任务
分享
--在title上建索引
select title from tabl1 with(index=索引名)
where title like 'key1%' or title like 'key2%'
or title like 'key3%
SELECT * FROM tableB
WHERE
charindex(tableA.fieldA,tableB.fieldB)>0
select title from tabl1 where title like '%key1%' or title like '%key2%'
or title like '%key3%' .......
select title from tabl1 where CHARINDEX('key1',title) =1 or CHARINDEX('key2,title) =1
or CHARINDEX('key3',title) =1 ......