MySQL在文本中查找关键字 [英] Mysql find keywords in text

问题描述

我有一个带有10k关键字的Mysql InnoDB表，我想将它们与多个文本进行匹配.

I have a Mysql InnoDB table with 10k keywords and I want to match them against several texts.

有些关键字有几个单词，我只想要完全匹配.

Some keywords have several words and I only want exact matchs.

示例: 关键字-棕狐，懒猫，狗，狐狸，兔子

Example: Keywords - brown fox, lazy cat, dog, fox, rabbit

文本-敏捷的棕色狐狸跳过了懒狗

Text - The quick brown fox jumps over the lazy dog

我希望查询返回-棕色的狐狸，狗，狐狸

I want the query to return - brown fox, dog, fox

推荐答案

SELECT * FROM tenKTable 
WHERE 'The quick brown fox jumps over the lazy dog' LIKE CONCAT('%',keyword,'%')

来源: MySQL SELECT查询字符串匹配

这篇关于MySQL在文本中查找关键字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！