Why is fulltextsearch for phrase ignored in SQL Server?
Posted
by
cpt.oneeye
on Stack Overflow
See other posts from Stack Overflow
or by cpt.oneeye
Published on 2013-10-26T15:49:14Z
Indexed on
2013/10/26
15:53 UTC
Read the original article
Hit count: 209
sql
|sql-server
I am executing the following SQL statement on an indexed SQL Server 2008 R2 database.
SELECT * FROM mydatabase WHERE (CONTAINS(ColumnA,'"The Apple is red"'))
The problem is that it returns too many entries. It also returns entries where 'ColumnA' contains only one of the words ('Apple' or 'is' or 'red'...) and not only the entries which contains the exact phrase.
According to MSDN this should be the way to search for a phrase.
Thanks cpt.oneeye
© Stack Overflow or respective owner