我正在 MySQL数据库中的静态记录中执行关键字文本搜索.是否可以构造一个查询来查找记录中的第一个关键字和相邻记录中的第二个关键字？请考虑以下示例数据.

------------------------------------------------------
| id | textstrings                                   |
------------------------------------------------------
|  1 | Every good boy does fine.                     |
|  2 | The quick brown fox jumPEd over the lazy dog. |
|  3 | I will not eat green eggs and ham.            |
|  4 | There is no time like the PResent.            |
|  5 | envy is an ugly shade of green.               |
------------------------------------------------------

搜索绿色棕色的术语应返回记录2和3,因为它们是相邻记录,但不应包含记录5,因为它不是具有记录3的邻居.

我知道我可以对任一单词执行查询并通过处理结果集来完成此操作,但我想知道是否可以将其构建到查询中.

该字段确实有一个FULLTEXT索引.

SELECT LEAST(t1.id,t2.id) AS id1,GREAtest(t1.id,t2.id) AS id2
From
(
    SELECT id
    From table
    WHERE textstrings LIKE '%green%'
) t1
INNER JOIN
(
    SELECT id
    FROM table
    WHERE textstrings LIKE '%brown%'
) t2
ON t1.id = t2.id - 1 OR t1.id = t2.id + 1
group by LEAST(t1.id,t2.id),t2.id)