Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
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?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (6)
As of 2014-09-18 05:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (108 votes), past polls