指定一定范围内的词首字符的 WHERE 子句

下列查询只选择 manu_code 以 A 到 H 开头的那些列，并返回结果显示的行。测试 '[A-H]' 指定从 A 到 H 之间（包括 A 和 H）的任何一个字母。对于 LIKE 关键字，不存在等价的通配符。

图: 查询

SELECT stock_num, manu_code, description, unit_price
          FROM stock
          WHERE manu_code MATCHES '[A-H]*'
          ORDER BY description, manu_code;

图: 查询结果

stock_num manu_code description     unit_price
              
              205 ANZ       3 golf balls       $312.00
              205 HRO       3 golf balls       $312.00
              2 HRO       baseball           $126.00
              3 HSK       baseball bat       $240.00
              1 HRO       baseball gloves    $250.00
              1 HSK       baseball gloves    $800.00
              7 HRO       basketball         $600.00
              ⋮
              313 ANZ       swim cap            $60.00
              6 ANZ       tennis ball         $48.00
              5 ANZ       tennis racquet      $19.80
              8 ANZ       volleyball         $840.00
              9 ANZ       volleyball net      $20.00
              304 ANZ       watch              $170.00