Hello I have set up fulltext searching on my productsearch table on the following columns:
Contributor, PrimItemNumber, SecItemNumber, Title
The promitemnumber and secitemnumber are ISBNs
I want to allow search on any of those columns and created a statement:
select productid, title
where freetext((Contributor, PrimItemNumber, SecItemNumber, Title), 'Bernadette DiFrancesco')
This brings back products where the contributor could have any combination of first and last names which contains the two words passed in.
I need it to narrow the results as more information is given.
if I use either of the isbn the exact product is returned. gTg
If a product title is passed in for example 'Gina Ds Cuddle Bug Christmas' then I get thousands of products where each word may be in the title.
Once again I must narrow the result set as more information is given.
How is this accomplished???