DROP TABLE IF EXISTS #products
CREATE TABLE #products (
  id INT NOT NULL PRIMARY KEY,
  ProductName VARCHAR(255) NOT NULL
);
INSERT INTO #products (id, ProductName)
VALUES
  (1, 'ABC代金券'),
  (2, '维生素发生器'),
  (3, '黑巧克力'),
  (4, '快速充电'),
  (5, '遥控器'),
  (6, '电力发生器'),
  (7, 'LED电视');
-
DROP TABLE IF EXISTS #Table_B
CREATE TABLE #Table_B (
    WordList VARCHAR(255) NOT NULL
);
INSERT INTO #Table_B (WordList)
VALUES
  ('发生器'),
  ('快速'),
  ('遥控器');
像"or"的Where条件中使用Like运算符在我的情况下不起作用，因为列表是动态且很长。
<details>
<summary>英文:</summary>
Following is the [Product] Table.
I want to select records from [Product] that contain words listed in Table_B.
| id | ProductName       |
|----|-------------------|
| 1  | ABC Voucher       |
| 2  | Vitamin Generator |
| 3  | Dark Chocolate    |
| 4  | Fast Charge       |
| 5  | Remote Controller |
| 6  | Power Generator   |
| 7  | LED TV            |
Following is Table_B (Which contains a list of Words)
| WordList   |
|------------|
| Generator  |
| Fast       |
| Controller |
**Required Output:**
| Sr | Full_List         |
|----|-------------------|
| 2  | Vitamin Generator |
| 4  | Fast Charge       |
| 5  | Remote Controller |
| 6  | Power Generator   |
For easy, following is the SQL Code for sample data:
    DROP TABLE IF EXISTS #products
    
    CREATE TABLE #products (
      id INT NOT NULL PRIMARY KEY,
      ProductName VARCHAR(255) NOT NULL
    );
    
    INSERT INTO #products (id, ProductName)
    VALUES
      (1, &#39;ABC Voucher&#39;),
      (2, &#39;Vitamin Generator&#39;),
      (3, &#39;Dark Chocolate&#39;),
      (4, &#39;Fast Charge&#39;),
      (5, &#39;Remote Controller&#39;),
      (6, &#39;Power Generator&#39;),
      (7, &#39;LED TV&#39;);
-
    DROP TABLE IF EXISTS #Table_B
    
    CREATE TABLE #Table_B (
        WordList VARCHAR(255) NOT NULL
    );
    
    INSERT INTO #Table_B (WordList)
    VALUES
      (&#39;Generator&#39;),
      (&#39;Fast&#39;),
      (&#39;Controller&#39;);
Like operator with &quot;or&quot; in Where condition will not work in my case as list is dynamic and long.
</details>
# 答案1
**得分**: 1
你可以将EXISTS与LIKE结合使用以实现你的需求。
```sql
SELECT * FROM #products p
WHERE EXISTS 
(
    SELECT * FROM #Table_B b 
    WHERE p.ProductName LIKE '%' + b.WordList + '%'
)

SELECT id, ProductName 
FROM Product 
WHERE ProductName IN 
(SELECT WordList FROM Table_B)