searching using multiple words
-
I have 6 columns in all my tables. All named the same thing. When trying to search using one word I get results regardless of what column the results came from. But combining word returns no results.
Example: I have a column named “store” and a column named “city”. I type “norfolk” in the search box and it returns results. I type WaWa and it returns results. I type WaWa Norfolk (meaning I want all wawas in norfolk to be displayed) and I’m getting no results.
This makes me believe that the search combines my 2 words and if those 2 words aren’t directly matched to a column it returns nothing.
If I am correct I would like to know how to make the search split the words and search all columns separately for
1: both words
2: one of the words
3: part of one of the wordsthx in advance
what I have now
[abase form=”1,search,/search-results/” table=”hotels” columns=”name=%name%$Search hotels” elements=”name,address,city,zip”]
[abase table=”hotels” SELECT * FROM hotels WHERE (name=’%<name>%’ OR city=’%<name>%’OR zip=’%<name>%’)
status=’1′ columns_in = ‘name, address, city, state, zip, phone’ rownum=”1″ ack=”1″ limit=”50”]
The topic ‘searching using multiple words’ is closed to new replies.
