UPDATE contraband From WHERE A title, details the REGEXP 'CONCAT (' %', ANY (SELECT prohibited From thesaurus contraband library), the '%') ', 
SELECT contraband From A; 

Electricity industry, the need to batch query table B (contraband library) of contraband thesaurus, match the title of A table, the detailed information of the existence of A keyword, if there is A return value to the contraband listed A table, the first word of A return to match,

CodePudding user response:

The join can be found out, but the efficiency is very pessimistic,,
Why don't you add a logo to table this field, or build a contraband task or message processing table,
When adding or modifying data check prohibited words, according to the result update logo or generated task or news??