MYSQL如何在一个句子中匹配两个单词

牛津是我的学校

oxford is my school

我的名字是kk学校是jes

my name is kk school is jes

等

如果您正在使用InnoDB表(并且您可能正在使用)，则可以使用LIKE语句:

If you're using InnoDB tables(and you probably are), you can use LIKE statement:

SELECT * FROM mytable WHERE mycolumn LIKE "%my%" OR mycolumn LIKE "%school%";

SELECT * FROM mytable WHERE mycolumn LIKE "%my%" OR mycolumn LIKE "%school%";

对于全文搜索，更好的解决方案是使用专用的搜索引擎，并为此进行了优化-例如 elasticsearch

For fulltext search much better solution would be using dedicated search engine, optimized for such purposes - for example elasticsearch.