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

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members