After looking at this SO question and doing my own research, it seems like you cannot have a basic template when using full-text search.
So, in the simplest example, if I have a table with 1 column, as shown below:
TABLE1
coin
minting
undercoin
select COLUMN1 from TABLE1 where COLUMN1 LIKE '%coin%'
Would get the results I want.
How can I get accurate results with FULL TEXT SEARCH enabled in a column?
The next two queries return the exact data, which is not quite what I want.
SELECT COLUMN1 FROM TABLE1 WHERE CONTAINS(COLUMN1, '"coin*"')
SELECT COLUMN1 FROM TABLE1 WHERE CONTAINS(COLUMN1, '"*coin*"')
source
share