Geek asks and answers

Using MySQL REGEXP in Boolean Match / Against

I have the following MySQL query:

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

here "regexp" searches for the "full word" colorado (with or without the ending "s").

I want to actually select only those lines that have (“Denver”) AND (“Colorado” or “Colorado”). But I can not put "+" for REGEXP. I tried, but got 0 results, although the table has rows that match the requirement.

Any ideas on how I can get a “+” to work using REGEXP? I am building this from a PHP script where "denver" and "colorado" are the values ​​of the variables that I use to create the select statement.

My PHP / MySQL script will look something like this:

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

, MATCH... BOOLEAN MODE. .

- :

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

More articles:


All Articles