Implied AND when searching: is it possible?

I would like to be able to use multiple search terms with AND implied between words entered in the search box, e.g. entering data access would return only those rows containing both data and access. I’m using the free version of WP Data Access at the moment, which appears to treat entered text as a literal string.

I found this at datatables.net/reference/option/searching: ‘Searching in DataTables is “smart” in that it allows the end user to input multiple words (space separated) and will match a row containing those words, even if not in the order that was specified (this allow matching across multiple columns).’ That seems to describe what I am looking for: a single word is treated as a discrete token, or any number of words separated by spaces are treated as discrete tokens – yet it is not how search works in WP Data Access, which I believe uses DataTables as its base.

Has WP Data Access changed the default search behaviour of DataTables, or have I misunderstood something? Are there any settings I can change to get this so-called smart search in WP Data Access?

Thanks for any help.

• This topic was modified 3 years, 2 months ago by trickystuka.