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 |
|
mattox
Starting Member
1 Post |
 Posted - 2008-12-07 : 20:00:27
|
| Hi all,I have a question about using Full Text Search, basically I've set it up and it works well. Got it to index one column of my database. Say I have 5 entries. 3 of them say Paris Hostel, the other 2 say Nice Hostel. If I search for Paris, the Paris entries show, if I search for Paris Hostel then all entries show. The current query code I'm using looks like: SELECT * FROM hostels WHEREFREETEXT(hostelTags, 'paris hostel') Any help would be greatly appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-07 : 20:38:38
|
| it looks for all possible matches, so even when you search for paris hotel it will look for entries with paris, hotel, paris hotel.... thats why it returns nice hotel entries as they also have hotel.it returns all matched words and even words that matches the meaninghttp://msdn.microsoft.com/en-us/library/ms176078.aspx |
 |
|
|
|
|
|
FTS Search!