1. Copy
app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext.php to
app/code/local/Mage/CatalogSearch/Model/Resource/ folder and open file.
2. Navigate to function prepareResult() and find below set of code:
$words = Mage::helper('core/string')->splitWords($queryText, true, $query->getMaxQueryWords());
foreach ($words as $word) {
$like[] = $helper->getCILike('s.data_index', $word, array('position' => 'any'));
}
and replace it with:
$like[] = '`s`.`data_index` LIKE :likew';
$bind[':likew'] = '%' . $queryText . '%';
Next replace
$likeCond = '(' . join(' OR ', $like) . ')';
with
$likeCond = '(' . join(' AND ', $like) . ')';
3. Login to Admin Panel of your magento. Navigate to System --> Configuration.
4. Now click on Catalog --> Catalog tab on left. In Catalog Search panel, set Search Type to like.
5. Just reindex all data and your store's search should be working fine now.
This process was tested on magento version 1.7.0 and above.