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%';