Re: Keyword searching across 2 tables

rgparkins@xxxxxxxxxxx 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.
.

Relevant Pages

  • Keyword searching across 2 tables
    ... to direct me in the techniques for performing this task. ... I have a table of stock with summary text of type text. ... who want to be alerted when their keywords are contained in a stock ... do I need to loop through ALL users and loop ...
    (comp.databases.theory)
  • Re: Keyword searching across 2 tables
    ... question was if a user has the following keywords.. ... Server but thought this is a generic SQL question and the application ... I have a table of stock with summary text of type text. ... do I need to loop through ALL users and loop ...
    (comp.databases.theory)
  • Buying and Selling Stocks by Technical Analysis
    ... time tested technical analysis techniques to ... analysis' or 'Stock Market Course' via their websites to the common ... MCCP qualification from India's largest commodity exchange Multi ...
    (misc.invest.stocks)
  • Re: WARNING- ON TOPIC: bio diesel
    ... you automatically limit yourself to tech considerations to diesel. ... It's always best to look at everything available, take stock of improvements in technology and techniques, and then do a process of elimination of the impractical solutions. ...
    (misc.survivalism)
  • Re: WARNING- ON TOPIC: bio diesel
    ... everything available, take stock of ... improvements in technology and techniques, ... and then do a process of elimination of the ...
    (misc.survivalism)