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 |
|
c@bleguy
Starting Member
2 Posts |
 Posted - 2002-05-27 : 17:31:39
|
| Hi, First of all I ain't a SQL expert. I am looking for a stored procedure that can do a fast search in 3 tables. The content of the tables are; - Site keywords - Site titles - Site descriptions There are 80 thousands records. A simple search as: SELECT TOP 20 FROM table WHERE column LIKE '%' + @Search + '%' Isn't enough. Cause when the keywords of a site are: house flower old dog car bike You won't find it when you search on 'flower bike'. Only when I do: WHERE column LIKE '%' + @Search + '%' AND '%' + @Search2 + '%' But that's to way to heavy when there a two more tables en for expample 4 keywords. I can use full text-search and it's a SQL 2000 server. Could anybody help this beginner ? Thnx :) |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-27 : 18:39:53
|
| Full-text indexing and searching are fully documented in Books Online, it's probably the most effective way to do the kinds of searches you describe.If you need another way, take a look at this:http://www.sqlteam.com/item.asp?ItemID=5857 |
 |
|
|
|
|
|
Search stored procedure