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.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • ... of my late father, who always used to confuse "AND" with "OR". His reasoning went something like "I want all the cases where city='Los Angeles' and all those where city='New York'", translated into SQL as
    SELECT *
    FROM records
    WHERE city='Los Angeles'
      AND city='New York'
    which returned rather few results.
    • That pesky English language. I guess in pseudocode that would be
      SELECT *
      FROM records
      WHERE city='Los Angeles'
      AND ALSO SELECT *
      FROM records
      WHERE city='Los Angeles'
      I'm an SQL newbie, though, so maybe there is some kind of do-multiple-selects-at-once (intersecting selects?) syntax that I'm not familiar with.