Advanced search with mysql OR statement - Magento

Question

I want to search with the advanced form, but with an mysql OR statement instead of AND statement.

For example I search for product ‘Nokia’ in Productname field and ‘N97’ in keywords field. The search results has to be Nokia OR N97.

Is there a way to fix this?

Answer 1

There is a way to configure it from search settings in admin page

System > Configuration > Catalog > Catalog > Catalog Search > Search Type