                     ----------  WHERE Clause  ----------

   WHERE ϥ쥳ɤ쥯Ȥ뤿ˡʤФʤʤꤹ
 Τ˻Ȥޤɽʤ "true"  "false" Τɤ餫ɾ
 ɽʤޤ

   WHERE  "and"  "or" Ƿ礵줿ɽȤäƹޤ

 ιʸ

     where |B_EXPR           |
           |(B_EXPR)         |
           |B_EXPR or B_EXPR |
           |B_EXPR and B_EXPR|
           |not B_EXPR       |

   Ĥɽ "and" Ƿ礹硢Τɽ true Ȥʤ뤿ˤ
 ξɽ true ǤʤФʤޤ


   Ĥɽ "or" Ƿ礹硢Τɽ true Ȥʤ뤿ˤ
 뤤ϡξɽ true ǤʤФޤ

   ξ˻ꤵ줿硢"and" 黻Ҥ "or" 黻Ҥͥ褷ޤ

   WHERE ϼηɽޤळȤǤޤ

     | EXPR [ |is      | ] CONDITION |
     |        |[is] not|             |
     |                               |
     | null EXPR                     |
     |                               |
     | exists SUBQUERY               |

CONDITION :

     | | =  | | EXPR     |                                             |
     | | != | | SUBQUERY |                                             |
     | | >  |                                                          |
     | | >= |                                                          |
     | | <  |                                                          |
     | | <= |                                                          |
     |                                                                 |
     | in (EXPR {, EXPR})                                              |
     | in SUBQUERY                                                     |
     |                                                                 |
     | like LIKE_PATTERN [ESCAPE_ATOM]                                 |
     |                                                                 |
     | | match   | PATTERN                                             |
     | | !match  |                                                     |
     | | smatch  |                                                     |
     | | !smatch |                                                     |
     |                                                                 |
     | [ | =  | ] null                                                 |
     |   | != |                                                        |
     |                                                                 |
     | between |EXPR    | [|exclusive|] [and] |EXPR    | [|exclusive|] |
     |         |SUBQUERY|  |inclusive|        |SUBQUERY|  |inclusive|  |
     |                                                                 |
     | range |EXPR    | [|exclusive|] [to] |EXPR    | [|exclusive|]    |
     |       |SUBQUERY|  |inclusive|       |SUBQUERY|  |inclusive|     |

   SUBQUERY ˤĤƤ "select" ޥɤ򻲾ȤƤ

   "Between ... and"  "range ... to" Ʊư򤷤ޤͤˤϾάͤȤơ
 inclusiveʴޤޤˤꤷޤ롼פξˤϡˤʤ
 ƤʤФʤޤ

   WHERE ǤΥѥޥå

     like:               ʸʸ̤ʤѥޥå
     match, !match:      ʸʸ̤ʤѥޥåȤ
     smatch, !smatch:    ʸʸ̤ѥޥåȤ

     "like" ANSI SQL Υѥޥå󥰱黻ҤǤ
     "match"  "smatch" ϥѥޥå󥰱黻ҤǤ

     LIKE_PATTERN °Ρ뤤Ϥΰȼüʸǻꤷޤ

              '_'  ǤդΣʸ
              '%'  ʸʾǤդʸ

         '_'  '%' ԤȤESCAPE_ATOM 


     PATTERN °Ρ뤤Ϥΰȼüʸǻꤷޤ

             '*'  ʸʾǤդʸ
             '?'  ǤդΣʸ
             '|'  ĤΥѥη硢쥯ȤˤϤɤ餫ޥå
                  Ф褤
             '&'  ĤΥѥη硢쥯Ȥˤξޥåʤ
                  Фʤʤ
             '\'  ΰʸ򤽤줬üʸǤäƤ̤ʸȤư

     ǤΤĤʸν򸡺ϡʸ [] ǰϤळ
 ˤꤷޤ

             [abc] Ϥξ "a" Ǥ "b" Ǥ "c" Ǥޤ

     ϰϤ "-" ǻꤷޤ

             [a-cf-i]  a, b, c, f, g, h, i ޤ

      "^" ǻꤷޤ

             [^123]  1, 2, 3 Ǥդʸޤ
             [^a-c] a, b, c Ǥդʸޤ

     ĤʸνǹǤդĹʸ򸡺ϡ
ʸСѤǰϤळȤˤꤷޤ

             {abc}  "a", "aa", "ab", "cacccbaa" ʤɤʸȥޥåޤ
             {[a-z]}  ʸǹ줿ʸȥޥåޤ

˾ɬפʾϡʲ˼ޥɤϤƤ

                help delete;
                help expr;
                help select;
                help update;
  
