I'm using this query in a Perl program:
SELECT Distinct x.Search FROM $source.Searches AS x LEFT JOIN searching.Status
AS s
ON x.Search=s.Search AND s.Source='$source' WHERE x.RedoTime<'$now' AND
s.Search IS NULL
This program runs other programs that do internet searches. I have different
sources (stored in $source, of course), and source has it's own DB with a
table, "Searches." Each row of searches describes a different search that can
be done and each search has a name, which is stored in the Searches column
(within the Searches table, so, yes, I use that name for a table and a column).
When a search is being executed, an entry is placed in searching.Status, with
one row in that table showing the status of the search.
So if I have a source named "alpha" and searches named "one" and "two" and the
system is executing the search "one," not only is there a row in alpha.Searches
describing "one" in depth, but there is a row in searching.Status describing
the progress with "one."
When each search is done, the RedoTime is set so it's easy to see when it needs
to be executed again.
What I want to do is get a list of searches in the Searches table (within the
source's DB) that are NOT listed in Status and where the RedoTime is before
$now (the current time).
From what I've read, the query above should do it, but I have this nagging
feeling I've done something wrong.
Will that query pick up all rows in $source.Searches that have a RedoTime
before $now that are NOT also listed in searching.Status?
Thanks for any help on this!
Hal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
