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.

use Perl

All the Perl that's Practical to Extract and Report

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

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

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

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) on 2009.06.30 16:25 (#69196) Homepage Journal
    
    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 subquery syntax is their subset, not TIMTOWTDI allowed.
    A fantastic free resource (which is in the corners specific to IBM DB2 but mostly standard ANSI SQL) is available for download or reference DB2 SQL Cookbook [verizon.net]
    
    --
    Bill
    # I had a sig when sigs were cool
    use Sig;
    
    Reply to This
    
    Parent

Get More Comments

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