Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

SQL queries from weird data

by Anonymous Monk
on Feb 19, 2013 at 15:13 UTC ( #1019585=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    /----------------------\
    | TYPE | STYPE | OTHER |
    \----------------------/
    
  2. or download this
    /----------------------\
    | TYPE | STYPE | OTHER |
    |----------------------|
    | AAA  | BBB   | X=CCC |
    \----------------------/
    
  3. or download this
    select * from targettablename where type='AAA' and stype='BBB' and x='
    +CCC';
    
  4. or download this
    /-----------------------------\
    | TYPE  | STYPE | OTHER       |
    ...
    |-----------------------------|
    | AA    | BB%   | X=CC%&Y=DD% |
    \-----------------------------/
    
  5. or download this
    select * from targettablename where type in ('AA','BB') and stype like
    + 'BB%' and X like 'CC%' and y='DDD';
    select * from targettablename where type in ('AA','BB') and X like 'CC
    +%' and y='DDD';
    select * from targettablename where type = 'AA' and stype like 'BB%' a
    +nd X like 'CC%' and y like 'DD%';
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1019585]
Front-paged by Corion
help
Chatterbox?
[shmem]: trading perl for python is just like throwing away a big tool box, to be given a hammer, a gripper and a screwdriver instead
[choroba]: but they're shiny!
[shmem]: ...and, a plethora of tools built with hammer, gripper and screwdriver, I should say

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (11)
As of 2018-04-20 13:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?