MATCH() AGAINST() mysql problems
Here's my problem.
I have a table 'search_info' with column 'keywords'. Here are two of the rows for the keywords column
1. lamp antique
2. Gorgoroth death metal CD music
Here are the results when I query with
MATCH(keywords) AGAINST("searchterms" IN BOOLEAN MODE)...
AGAINST("lam*" IN BOOLEAN MODE) retrieves row 1 (lam* = lamp)
AGAINST("gor*" IN BOOLEAN MODE) retrieves row 2 (gor* = gorgoroth)
AGAINST("lamp Gorgoroth" IN BOOLEAN MODE) retrieves both rows
But...
AGAINST("lam* gor*" IN BOOLEAN MODE) or
AGAINST("gor* lam*" IN BOOLEAN MODE)
only retrieves row 2. Why doesn't it retrieve both rows?
|