
实例
复制mysql> SELECT * FROM pet WHERE name LIKE "b%";              +--------+--------+---------+------+------------+------------+              | name | owner | species | sex | birth | death |              +--------+--------+---------+------+------------+------------+              | Buffy | Harold | dog | f | 1989-05-13 | NULL |              | Bowser | Diane | dog | m | 1989-08-31 | 1995-07-29 |              +--------+--------+---------+------+------------+------------+             1.2.3.4.5.6.7.