22,207
社区成员
发帖
与我相关
我的任务
分享
;WITH CTEWT
AS
(
SELECT a.KCID,SUBSTRING(a.Words,b.number,CHARINDEX(' ',a.Words+' ',b.number)-b.number) AS Words
FROM WordsTab AS a
INNER JOIN master.dbo.spt_values AS b ON b.type='P' AND b.number>=0 AND CHARINDEX(' ',' '+a.Words,b.number)=b.number
)
SELECT * FROM CTEWT AS a INNER JOIN Course AS b ON b.Title LIKE '%'+a.Words+'%'
SELECT * FROM WordsTab AS a INNER JOIN Course AS b ON b.Title LIKE '%'+REPLACE(a.Words,' ','_')+'%'