String content: today I want to use/all across this account to DE Marcia area to play games, please open black,
Now need to go through the string content, match the data in the column (interceptWords), find out all CDH, DE Marcia, two columns;
SQL is as follows:
The select i.i d, i.i nterceptWords from intercept_words I
Where 'today, I want to use all across this account to DE Marcia area to play games, please open the black' like CONCAT (' % 'and i.i nterceptWords,' % ');
Results:
