In a view, I am using an exposed filter of keyword search (Search: Search Terms). The default behavior of the filter is to select exact matches. I need to have similar words also selected. For instance when the visitor searches for "paint", she should see "painting" or "painter" too.

Similar to the "LIKE" operator in mysql.

1 Answer 1


When you set a new filter in views on a field (for example node title), you can set the Operator to contains which is the equivalent of SQL LIKE. You can also expose the filter and the operator to the visitor. If you want to see the SQL query in the preview, check the option Show the SQL query in view setting.

Instead of Search: Search Terms, use Global: Combine fields filter; it will allow you to search multiple fields using the operator you want.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.