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: 206

Filed under:
|

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

Related posts about sql

Related posts about sql-server