布尔匹配/反对中的MySQL REGEXP用法(MySQL REGEXP usage within Boolean Match/Against)

布尔匹配/反对中的MySQL REGEXP用法(MySQL REGEXP usage within Boolean Match/Against)

我有以下MySQL查询：

SELECT标题，描述FROM some_table WHERE MATCH（标题，描述）AGAINST（'+ denver（REGEXP“[[：<：]] colorado [s] * [[：>：]]”）'在BOOLEAN MODE中）;

这里的“regexp”寻找一个“完整的单词”科罗拉多（有或没有结尾的“s”）。

我想实际上只选择那些有（“denver”）AND（“colorado”或“colorados”）的行。 但我不能为REGEXP加上“+”。 虽然表中的行符合要求，但我尝试了但得到了0个结果。

关于如何让“+”使用REGEXP来解决问题的任何想法？ 我在PHP脚本中构造它，其中“denver”和“colorado”是我用来构造select语句的变量值。

我的PHP / MySQL脚本看起来有点像这样：

SELECT标题，描述FROM some_table WHERE MATCH（标题，描述）AGAINST（'+ $ var1（REGEXP“[[：<：]] $ var2 [s] * [[：>：]]”）'在BOOLEAN MODE中）;

I have the following MySQL query:

SELECT title, description FROM some_table WHERE MATCH (title,description) AGAINST ('+denver (REGEXP "[[:<:]]colorado[s]*[[:>:]]")' IN BOOLEAN MODE);

the "regexp" here looks for a "complete word" colorado (with or without the ending "s").

I want to actually select only those rows that have ("denver") AND ("colorado" or "colorados"). But I cannot put a "+" for the REGEXP. I tried but got 0 results, although there are rows in the table that match the requirement.

Any ideas on how I can get the "+" to work within against using a REGEXP? I am constructing this from within a PHP script where "denver" and "colorado" are values of variables I use to construct the select statement.

My PHP/MySQL script would look somewhat like this:

SELECT title, description FROM some_table WHERE MATCH (title,description) AGAINST ('+$var1 (REGEXP "[[:<:]]$var2[s]*[[:>:]]")' IN BOOLEAN MODE);

最满意答案

我认为不可能将正则表达式和MATCH结合起来......在BOOLEAN模式中。 您需要使用语法来编写布尔表达式。

布尔全文搜索

尝试这样的事情：

SELECT title, description FROM some_table WHERE MATCH (title,description) AGAINST ('+denver +(colorado colorados)' IN BOOLEAN MODE);

I don't think it's possible to combine regular expressions and MATCH ... IN BOOLEAN MODE. You need to use the syntax for writing boolean expressions.

Boolean Full-Text Searches

Try something like this:

SELECT title, description FROM some_table WHERE MATCH (title,description) AGAINST ('+denver +(colorado colorados)' IN BOOLEAN MODE);