如何在Drupal 7中进行％LIKE％搜索

Question

I got Drupal 7 and ubercart installed. I'm using standart shaerch engine. How can i search in my store using queries like this:

SELECT * FROM table WHERE product_desc LIKE %search_word%

What files i need to change to search with part-words?

Answer 1

The core search module only does exact match search. You could try the Porter-Stemmer module to get the "LIKE" search if your site is English language only.

A more flexible approach would be to use the Views module and create a search form that is for your products. Performance would be better and you could easily extend the functionality in the future.