Using LOTS of keywords in a select....can anyone help?! - DML (SELECT, INSERT, UPDATE, DELETE) Questions

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » Transact-SQL Programming » DML (SELECT, INSERT, UPDATE, DELETE) Questions » Using LOTS of keywords in a select....can anyone help?!

Using LOTS of keywords in a select....can anyone help?!

Options

Previous Topic · Next Topic

tftr_si

Posted: Wednesday, February 20, 2008 7:53:53 AM

Rank: Newbie

Joined: 2/20/2008
Posts: 1
Points: 3
Location: UK

Hi guys,
I was wondering if you could help me. I have a keyword matching system idea and I need to figure out if it is feasible and if so, roughly how I would go about doing it.

Basically, I have an article being posted on my site. The hard part is that each word of that article then needs to be used as a 'keyword' to match up against users (via a comma seperated list of words in the users table) and return the list of matches.

Is there a way of doing this? Would Full-Text Indexing help? Any comments would be greatly appreciated!!!

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.