with small (term) as (
        select 'fishing'
  union select 'pond'
  union select 'cloud'
  union select 'big one'
  union select 'house'
)

select term
from small
where 'I have a pond at my house. I decided to go fishing and caught a big one.' 
  REGEXP concat('(^|.*[^a-z])', term, '([^a-z].*|$)') = 1

不管输入的字符串有多大，都可以使用FULLTEXT索引。
然后使用以下命令：

SELECT * FROM `table_name` 
WHERE MATCH(records) AGAINST ('"your large string"' IN BOOLEAN MODE) AS relevance;

有关更多信息，请参阅这些答案：

• MySQL match() against() - order by relevance and column?
• MySQL MATCH() AGAINST() FULLTEXT Index - Achieve Partial String Match Combined with Phrase Match
• MySql MATCH AGAINST and LIKE combination to search for special characters