CentOS 7
Sponsored Link

SQL Server 2019 : Full-Text Search2020/01/20

 
Install SQL Server Full-Text Search to enable Full-Text Search on tables.
[1] Install SQL Server Full-Text Search. (from MS SQL 2019 repo)
[root@dlp ~]#
yum -y install mssql-server-fts
[root@dlp ~]#
systemctl restart mssql-server

[2] Test to run Full-Text Search.
[root@dlp ~]#
sqlcmd -S localhost -U SA

Password:

# connect to the test database
1> use SampleDB;
2> go
Changed database context to 'SampleDB'.

# sample table for test
1> select * from dbo.Sample_Table;
2> go
ID         Name        Description                                           
---------- ----------- ------------------------------------------------------
01         CentOS      This is the Community Enterprise Operating System.    
02         RedHat      RedHat Enterprise Linux.                              
03         Debian      Debian GNU Linux.                                     
04         Ubuntu      Ubuntu is based on the Debian architecture.           
05         Windows     Microsoft Windows                                     

(5 rows affected)

# create fulltext catalog named [Sample_TBCat]
1> create fulltext catalog Sample_TBCat;
2> go

# create unique index to [ID] column named [UIDoc]
1> create unique index UIDoc on Sample_Table(ID);
2> go

# create fulltext index on [Sample_TBCat] catalog
1> create fulltext index on Sample_Table(Name,Description)
2> key index UIDoc on Sample_TBCat;
3> go


# test to run full-text search
1> select * from dbo.Sample_Table where contains((Name,Description),'Enterprise');
2> go
ID         Name          Description                                            
---------- ------------- -------------------------------------------------------
02         RedHat        RedHat Enterprise Linux.                               
01         CentOS        This is the Community Enterprise Operating System.     

(2 rows affected)

# test to run full-text search
1> select * from dbo.Sample_Table where freetext((Description),'GNU or architecture');
2> go
ID         Name         Description                                    
---------- ------------ -----------------------------------------------
03         Debian       Debian GNU Linux.                              
04         Ubuntu       Ubuntu is based on the Debian architecture.    

(2 rows affected)
Matched Content