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 - 06:37:07 CDT
