select * from Test_User_Topic a,Test_KeyWord b
where len(a.ResultText) > 0 and
a.ResultText LIKE '%' + b.KeyWord + '%'
where len(a.ResultText) > 0 and
a.ResultText LIKE '%' + b.KeyWord + '%'
a.userid,a.ResultText,b.*
FROM
Test_User_Topic a
inner JOIN
dbo.Test_KeyWord b
ON
a.ResultText LIKE '%' + b.KeyWord + '%'
--或者charindex(b.KeyWord,a.ResultText)>0
WHERE
len(ResultText) > 0
update Test_KeyWord set keyword=left(keyword,len(keyword)-2)强行干掉了。浪费好多时间!!
SELECT a.userid, *
FROM (SELECT [UserID], ResultText
FROM Test_User_Topic
WHERE len(ResultText) > 0) a inner JOIN
dbo.Test_KeyWord b ON a.ResultText LIKE '%' & b.KeyWord & '%'