MySQL Sub search - Is there such a thing?

From: Vernon (vernon_at_comp-wiz.com)
Date: 12/31/03 

To: php-general@lists.php.net
Date: Tue, 30 Dec 2003 18:00:50 -0500

Some one is asking me to create a sub search on a search that has already
been done. For instance, the database has 50,000 records, a user does a
search for two keywords which yielded 1700 records. They want to now filter
that list with other keywords. The logic is that searching 1700 records has
got to be faster than searching 50,000 records.

The only way I know how to do this is to save the results of the pervious
search to hidden fields and allow the user to add more keywords, which in
essence isn't doing other than adding more keywords to the search doing the
same exact thing they did before with new keywords. Is this logic correct or
is there a way to save that queries results and search only that?

Thanks

Relevant Pages

  • Re: [PHP] MySQL Sub search - Is there such a thing?
    ... Vernon wrote: ... For instance, the database has 50,000 records, a user does a ... > search for two keywords which yielded 1700 records. ...
    (php.general)
  • Re: Algoritim - Create Unique Integer from String
    ... back to the original string), only that a unique string produce a unique ... spam categorizer uses some sort of one-way hash for its Naive Bayes ... It breaks the messages up into keywords, ... before it stores them in the database (or compares them to existing ...
    (comp.programming)
  • Re: Can I use Access (2007) for sorting scanned documents?
    ... I think I may have to create a table of 'Keywords' and link this to the ... documents in the database, then click on a hyperlink and open them. ... e.g. there are hundreds of memorandum for record files, ...
    (microsoft.public.access.gettingstarted)
  • Re: Commas in URLs?
    ... > entries are also commonly used for this purpose, ... > used bibliographic database app EndNote has a "URL" field in each entry. ... > the multiple keywords in EndNote Keywords field, ... > delimiter for individual keywords in that field is the comma. ...
    (comp.infosystems.www.authoring.html)
  • Re: thread problem
    ... You could simply search for the text within the database and then fill the ... If the user will use mostly 'keywords' and not full phrases for their ... I left out suggesting incremental loading of the data out of my ... Windows Explorer gets away with it by using some highly optimized code, ...
    (microsoft.public.vb.general.discussion)