Search in a Table

Question

How to make a freetext search. What changes we have to do with our database table . Explain it Step by Step Rahul Saxena 14rahulsaxena@gmail.com

BYPsoft · Answer

Hi Why you are re-posting my post? What is meaning of this?

san ja · Answer

Hi You can do FULLTEXT search by enabling option from databse. you have to just right click on database and click on enable FULLTEXT after that you have to start fulltext index. or u want it for perticular table u can do that by following. Your table where you want to use full text search should have unique index on one column. CREATE UNIQUE INDEX ft_yourindex ON your_schema].[your_table]([column_name]); Create default full text catalog CREATE FULLTEXT CATALOG [some_name] AS DEFAULT; Create full text index finally CREATE FULLTEXT INDEX ON [your_schema].[your_table_containing_unique_index_on_column]([any_column_from_that_table]) KEY INDEX ft_yourindex; Finally use that index SELECT [your_columns] FROM [your_table] WHERE CONTAINS ([full_text_index_column]'lookup_keyword');

BYPsoft · Answer

Hi here are steps required to enable and use fulltext search on SQL Server: Enable fulltext search on your database by running EXEC sp_fulltext_database 'enable' It is possible also to use SQL Server Management studio select your database choose Properties and on Files check Use Full text indexing; Your table where you want to use full text search should have unique index on one column. CREATE UNIQUE INDEX ft_yourindex ON [your_schema].[your_table]([column_name]); Create default full text catalog CREATE FULLTEXT CATALOG [some_name] AS DEFAULT; Create full text index finally CREATE FULLTEXT INDEX ON [your_schema].[your_table_containing_unique_index_on_column]([any_column_from_that_table]) KEY INDEX ft_yourindex; Finally use that index SELECT [your_columns] FROM [your_table] WHERE CONTAINS ([full_text_index_column]'lookup_keyword'); Hope it is clear now.