Re: Keyword searching across 2 tables
Date: Tue, 11 Jul 2006 11:37:07 GMT
Message-ID: <D3Msg.9049$pu3.203530_at_ursa-nb00s0.nbnet.nb.ca>
rgparkins_at_hotmail.com wrote:
> Hi,
>
> I have a problem that is possibly been solved but I really need someone
> to direct me in the techniques for performing this task. I am using SQL
> Server but thought this is a generic SQL question and the application
> is a website.
>
> I have a table of stock with summary text of type text. I have users
> who want to be alerted when their keywords are contained in a stock
> summary when a new stock is added to the database. (A user can have
> many keywords and they must all be contained in the summary)
>
> Here comes my question, do I need to loop through ALL users and loop
> through each keyword a user has defined? Is there a standard technique
> for this kind of match?
Yes, it's called a join. You probably want to look up the LIKE keyword too. Received on Tue Jul 11 2006 - 13:37:07 CEST