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 |
|
querybest
Starting Member
22 Posts |
 Posted - 2005-08-12 : 02:47:58
|
| [code]FREETEXTTABLE(tbl,field,'asp AND php')[/code]Don't we use AND statement with FREETEXTTABLE in full text search ?'asp and php' is working like 'asp OR php'and it gets records that have not asp AND php words at the same time ?FREETEXTTABLE's rank propertiy is very powerful for me..that is the why I intend to use it |
|
|
querybest
Starting Member
22 Posts |
Posted - 2005-08-12 : 03:21:02
|
| sorry, CONTAINSTABLE instead of FREETEXTTABLE is what I need.but I dont want to remove this topic, maybe someone needsnext question.I indexed two columns..title and description are name of themSELECT M.* FROM tbl AS M INNER JOIN CONTAINSTABLE(tbl,title,'"soccer"') AS A ON M.[id]=A.[KEY] ORDER BY A.RANK DESCthis is okay.but How can I add to it a new CONTAINSTABLE for column of descriptionCONTAINSTABLE (tbl,description,'"soccer"')soccer must exist in title OR in description.but ordering by must be by two of them |
 |
|
|
|
|
|
FREETEXTTABLE with AND