Link to home
Start Free TrialLog in
Avatar of hankknight
hankknightFlag for Canada

asked on

mySQL: IN BOOLEAN MODE WITH QUERY EXPANSION

I like using "WITH QUERY EXPANSION" because it does a good job at breading the results.

However I need support for "IN BOOLEAN MODE" because
          food -bank
should remove bank-related results.

When I combine IN BOOLEAN MODE and WITH QUERY EXPANSION I get an error.
select count(`name`) as numrows from `organizations` WHERE ( replace(replace(`name`, ' ', ''),'\'', '') LIKE '%food-bank%' OR replace(`keywords`, ' ', '') LIKE '%food-bank%' OR MATCH (`name`,`keywords`,`description`,`custom_keywords`,`naics_keywords`, `naics_desc`, `p_city`, `promo_text`) AGAINST ('food -bank' IN BOOLEAN MODE WITH QUERY EXPANSION) )

Open in new window

SOLUTION
Avatar of NerdsOfTech
NerdsOfTech
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
What is your goal for this?
What is the error?
Avatar of hankknight

ASKER

This is no such thing as "IN BOOLEAN MODE and WITH QUERY EXPANSION"  but can I accomplish the same thing with a revised query?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial