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 |
|
sickhead
Starting Member
5 Posts |
 Posted - 2002-11-08 : 10:52:13
|
| hey everybody,i've got a fulltext-table with 4 fulltext-columns for an event calendar. the columns contain info about location, organisator and a description.i call a sp which consists of paging function and the following select: SELECT *FROM kalenderWHERE CONTAINS(*, 'mountainbiking and dobratsch')one column contains 'mountainbiking' in the description and'dobratsch' in the location but the row isn't found.whats wrong here?thxsickheadtoo much of a beautiful thing is wonderful |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-08 : 11:14:40
|
| Heard of this before.Think it may be a feature==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-11-08 : 15:43:51
|
| Whilst the * means search all columns, CONTAINS will only return rows where both values are contained in a single column. There are a number of ways round this dependong on the volatility and amount of data. One is to split the search phrase and perform multiple selects unioned together.Another, which we use since our product list is built once a day, is to create a new table containing the primary key of the base table plus the columns that we want to search e.g. author,title,imprint,short description concatenated together in a second column. This way we can use CONTAINSTABLE and hit the full text index only once whilst still searching across all columns.HTHJasper SmithEdited by - jasper_smith on 11/08/2002 15:44:25 |
|
|
|
|
|
|
Full Text Search