I went to this line in app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext.php and did this (below) copy app/code/core/Mage/CatalogSearch/Model/Mysql4/Fulltext.php to app/code/local/Mage/CatalogSearch/Model/Mysql4/Fulltext.php line 341 - 343 app/code/local/Mage/CatalogSearch/Model/Mysql4/Fulltext.php if ($like) {$likeCond = '(' . join(' OR ', $like) . ')';}change into if ($like) {$likeCond = '(' . join(' AND ', $like) . ')';} |
http://stackoverflow.com/questions/1953715/magento-search-not-returning-expected-results