CentOS 7
Sponsored Link

SQL Server 2017 : Full-Text Search
2017/10/11
 
Install SQL Server Full-Text Search to enable Full-Text Search on tables.
[1] Install SQL Server Full-Text Search. (from MS SQL 2017 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 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                                         
---------- ------------------ ----------------------------------------------------
001        CentOS             This is the Community Enterprise Operating System.  
002        RedHat             RedHat Enterprise Linux.                            

(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                                         
---------- ------------------ ----------------------------------------------------
004        Ubuntu             Ubuntu is based on the Debian architecture.         
003        Debian             Debian GNU Linux.                                   

(2 rows affected)
Matched Content
 
Tweet