hankknight
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.
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) )
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What is your goal for this?
What is the error?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.