use Perl

• how about using IN? (Score:1)

  by ddick (5726)

  SELECT word FROM dict WHERE word IN ('aaaaa','bbbbb','ccccc',....)
  • Re: (Score:2)

    by ambs (3914)

    This means I did not know SQL enough. Let me try it :)
    • Enough SQL Re:how about using IN? (Score:1)

      by n1vux (1492)

      O'Reilly has some general titles in both portable paperback [oreilly.com] and online formats such as SQL Cookbook [safaribooksonline.com] , SQL Hacks [safaribooksonline.com] , SQL Pocket Guide, 2nd Ed [safaribooksonline.com] , Head First SQL [safaribooksonline.com] , SQL in a Nutshell, 3rd Ed [safaribooksonline.com]. I mention these since they're not specific to any one vendor.

      The DB vendor website should have online docs for how much of latest ANSI spec each release has implemented with what divergences (to be polite). I frequently have the MySQL website's manual section open when working on my dot.org site SQL, since their s

      --
      Bill
      # I had a sig when sigs were cool
      use Sig;
  • Re: (Score:2)

    by ambs (3914)

    It worked. THANK YOU!
    • Re: (Score:2)

      by htoug (771)

      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
• Not that complex (Score:1)

  by Arador (8415)

  That's not complex, just big. I once did a 18 fold join: that is much more complex (without using views it wouldn't have been manageable).