full text search weighting on different columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Duncan Welch - 23 Jun 2004 22:36 GMT

Hi,

I've not used FT much, but I've successfully created a CONTAINSTABLE query
on a database that contains names and addresses, using a wildcard for the
field names.

Can anyone please point me in the right direction for info on how to
"weight" one field over another? For example - if someone searches for
"John", the system needs to rank "John Smith" in the "name" column over "10
St John St" in the "address1" column.

Thanks in advance,

Dunc

Reply to this Message

John Kane - 24 Jun 2004 03:37 GMT

Duncan,
You must join two or more CONTAINSTABLE from the same table or multiple
tables and then use the appropriate weight for each predicate, for example
using the Northwind table Employees and two FT-enabled columns:

SELECT e.LastName, e.FirstName, e.Title, e.Notes
from Employees AS e,
containstable(Employees, Notes, 'ISABOUT (BA weight (.2) )', 10) as A,
containstable(Employees, Title, 'ISABOUT (Sales weight (.5) )', 15) as
B
where
A.[KEY] = e.EmployeeID and
B.[KEY] = e.EmployeeID

Regards,
John

> Hi,
>
[quoted text clipped - 10 lines]
>
> Dunc

Reply to this Message