Search Database field containing keywords in any order

I have a single field search form (like google) which searches a Database table field containing Titles of Books. In the Database Query, I have the condition as CONTAINS. But if the Title is say “Wappler is the Best Development Platform” and I type in the search “Wappler Best” is won’t find it, but if I search say “Wappler is” then it would find it.

Is there a way to allow search of the keywords with being precise about the order which the user types them?

Community Page
Last updated: