Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lee.jenkins
Starting Member
5 Posts |
 Posted - 2009-05-18 : 14:48:17
|
| guys,I have a question about the fulltext index, I have a table, one of the column is varchar(300) type, I created fulltext index on this column.The value of one row for this column is [get up for lunch](without []). I am running following queries:1. SELECT * FROM tbl_xxx WHERE CONTAINS(name, '"get AND up AND for AND lunch"')this query return empty dataset.2. SELECT * FROM tbl_xxx WHERE CONTAINS(name, '"get up for lunch"')this query return 1 row which is the target row.3. SELECT * FROM tbl_xxx WHERE CONTAINS(name, '"get" AND "up" AND "for" AND "lunch"')this query return empty dataset.4. SELECT * FROM tbl_xxx WHERE CONTAINS(name, '"get AND up AND for"')this query return several rows contains the target row.I was thinking about the query 1 and query 3 should be the correct query to get the correct result(1 row), but how come it won't work? What is the difference between those 4 queries? Thanks a lot for the help. |
|
|
|
|
|
Question about fulltext index result