mysql - MySQL中基于表内容的动态正则表达式

Question

是否可以在 MySQL 中执行此操作？

select * from keyword 
where keyword NOT REGEX concat('\b', concat_ws('\b|\b', (select distinct(keyword) from negative_keyword)), '\b') 
limit 3;

它目前给出了这个错误:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REGEX concat_ws('|', (select distinct(keyword) from negative_keyword)) limit 3' at line 1

concat_ws 本身给出了这个错误:

ERROR 1242 (21000): Subquery returns more than 1 row

我必须匹配整个单词，而不仅仅是子字符串或完全匹配。例如，否定关键字“猫”应该匹配“黑猫”，而不是“紧张症”。

Answer 1

SELECT  *
    FROM  x
    WHERE  NOT EXISTS 
      ( SELECT  *
            FROM  negative_keywords nk
            WHERE  nk.keyword = x.keyword 
      );