I am using autocomplete for my website,so i want to implement full-text search
in application,so tell me the best approach to write query.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sandeep ShekhawatPosted Jun 28, 2011, 7:18 AM
http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/
By above Link there author is :
1)Nipun Tomar
2)pinaldave
Form Nipun Tomar article write first of all in ur database query window:
exec sp_fulltext_database 'enable'
It will enable your database for full text search then after it
u follow pinaldave blog steps:
at last write this query
select * from adminlogin where freetext(*,'admin')
Here adminlogin is table name that is enable for full text search and 'admin' is a word that i will be search. u can pass this word from your textbox as parameter via storeprocedure to query.
OUTPUT Will Be