Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

You know you are doing too complex SQL queries... 3 Comments More | Login | Reply /

 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • SELECT word FROM dict WHERE word IN ('aaaaa','bbbbb','ccccc',....)
    • It worked. THANK YOU!

      • I will (possibly) fail when the list of word in the 'IN'-clause gets long enough.
        I had problems with clauses longer than approx 100_000 in an old version of Ingres.

        The solution was to create a temporary table with all the words and then use this in the 'IN'-clause.

          CREATE TEMPORARY TABLE words(word VARCHAR(100));
          INSERT INTO words VALUES('aaaaa'); ....
          INSERT INTO words VALUES('xxxxx');
          SELECT word FROM dict WHERE word IN (SELECT word FROM WORDS);

        (SQl-code is suboptimal, but you get the idea I hope).

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.