DataAssist Search Comparisons
I have 2 search fields, one for keywords and the other for areas (suburb or postcode). They are both set to keyword and "includes" and "=" respectively.
I have 2 problems:
1. i want users to be able to search using either or both of the fields, eg: widgets Melbourne OR just Widgets OR just Melbourne.
2. Currently if a user searches for eg: camera melbourne the results are correct BUT if the user searches for eg: cameras melbourne there are NO results. I have tried "begins with" which does not work as the database records are eg: Nikon Digital Camera, so it would look at Nikon first and fail. I have tried changing the first filed to "includes" which only works for camera NOT cameras.