[thelist] SQL Query Question
Jay Blanchard
jay.blanchard at niicommunications.com
Mon Apr 15 13:14:01 CDT 2002
[snip]
SELECT this, that, theother
FROM tblFOO
WHERE theother NOT IN ('item1', 'item2', 'item3')
Does that do what you want?
[/snip]
Yes, but I don't want to have to change the query for each list item. Since
those items are maintained in another table and can vary from day to day I
want to be able to do this in an automated fashion. If I cannot do it
because of the limitations of MySQL 3.2x (4.x allows sub-queries, but has
not been released as stable yet) I will have to parse the file with the
appropriate constraints (with an AWK script), and import that parsed file
into the db. It would make life so much simpler if I could just parse the
whole file, import that parsed file into the db and then issue a query.
Jay
More information about the thelist
mailing list