Forums
This topic is locked
Advanced search - search multiple keywords
Posted 10 Oct 2006 20:35:02
1
has voted
10 Oct 2006 20:35:02 Dan Berdusco posted:
Hi All,I am attempting to create a search on a database in which I can search a specific database field for keywords. The problem i am coming accross is this:
<b>The data in the database field is this:</b>
"Oldman River Dam and reservoir follow-up environmental impact assessment review of fish, fish habitat and invertebrates"
-----------------------------------------------------
If I search for the word <b>"Oldman"</b> or <b>"Oldman River Dam"</b> then the result comes up perfectly. However, I need a way so that if a user types in <b>"Oldman resevoir"</b> then the result will display (obviously it will not currently display). I need to be able to search each keyword entered alone - not as a phrase.
Thanks... Any help is very much appreciated.