以下是[产品]表.
我想从[Product]中 Select 包含表_B中列出的单词的记录.
id | ProductName |
---|---|
1 | ABC Voucher |
2 | Vitamin Generator |
3 | Dark Chocolate |
4 | Fast Charge |
5 | Remote Controller |
6 | Power Generator |
7 | LED TV |
下表_B(包含单词列表)
WordList |
---|
Generator |
Fast |
Controller |
Required Output:个
Sr | Full_List |
---|---|
2 | Vitamin Generator |
4 | Fast Charge |
5 | Remote Controller |
6 | Power Generator |
为方便起见,以下是示例数据的SQL代码:
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 Voucher'),
(2, 'Vitamin Generator'),
(3, 'Dark Chocolate'),
(4, 'Fast Charge'),
(5, 'Remote Controller'),
(6, 'Power Generator'),
(7, 'LED TV');
DROP TABLE IF EXISTS #Table_B
CREATE TABLE #Table_B (
WordList VARCHAR(255) NOT NULL
);
INSERT INTO #Table_B (WordList)
VALUES
('Generator'),
('Fast'),
('Controller');
在WHERE条件中带有"or"的LIKE运算符在我的例子中不起作用,因为列表是动态的且很长.