how i distribute weights opposite columns full calm search?
in full calm hunt query, i wish distribute sole columns aloft weightage. cruise query:
select key_table.rank, ft_table.* restaurants ft_table
inner join freetexttable(restaurants, *, 'chilly chicken') key_table
on ft_table.restaurantid = key_table.[key]
order key_table.rank desc
now, i wish name buttress have aloft weightage law (name, keywords plcae full-text indexed). currently, outcome found any 3 columns, ranks affected.
for example, i'd quarrel name "chilly chicken" have aloft arrange keywords "chilly chicken", nonetheless another name.
edit:
i'm regretful containstable, since meant separating phrases (chilly chicken, etc.), secure me carrying hunt illusory combinations - cold chicken, cold chicken, etc. i fts engine automatically figure out law review best, i cruise freetext does glorious office way.
apologies i've misunderstood contains/containstable works.
Comments
Post a Comment