MySQL:什么是LIKE的反向版本? [英] MySQL: What is a reverse version of LIKE?

问题描述

LIKE 运算符用于查找包含我们的查询文本的行，例如:

LIKE operator in MySql is used to find rows that contain our query text, for example:

select name from user where name like "%john%"

将返回John Smith，Peter Johnson等.

如果我需要相反的操作-在我们的查询文本中查找包含 CONTAINED 的行怎么办?例如，我给它John Smith and Peter Johnson are best friends并希望它从该字符串中可以找到的表中查找所有名称.

What if I need the opposite - to find rows that are CONTAINED in our query text? For example I give it John Smith and Peter Johnson are best friends and want it to find me all names from the table that could be found in this string.

该怎么做?

推荐答案

以下是您可以实现所描述内容的一种方法:

Here's a way you can achieve what you describe:

SELECT name FROM user 
WHERE 'John Smith and Peter Johnson are best friends' LIKE
  CONCAT('%', name, '%')

这篇关于MySQL:什么是LIKE的反向版本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！