Reply To: Getting better search results from multi term queries

11/08/2013 at 1:19 pm #273273
Steven Zahm
Keymaster

@ roy

That sounds about right. The LIKE query is OR. Making it AND makes the query results to small by being too specific.

FULLTEXT is multiterm, just not across fields. Entering “Oceanic” and “Moscow” would yield results for only entries that contain both terms in the same field. Since one term is in the organization field and the other is in the city field would equal no results.