mysql> select * from student;
+------+------+-----------+
| age | name | address |
+------+------+-----------+
| 12 | Jack | BeiJing |
| 19 | Mike | TianJin |
| 21 | Rose | ZhuHai |
| 23 | Ann | ShangHai |
| 27 | Alis | ShenZhen |
| 55 | Make | GuangZhou |
+------+------+-----------+
6 rows in set (0.00 sec)
mysql>
# regexp关键字,查找含有“A开头”的name
mysql> select name, name regexp '^A' from student;
+------+------------------+
| name | name regexp '^A' |
+------+------------------+
| Jack | 0 |
| Mike | 0 |
| Rose | 0 |
| Ann | 1 |
| Alis | 1 |
| Make | 0 |
+------+------------------+
6 rows in set (0.07 sec)
# regexp关键字,查找含有“i结尾”的address
mysql> select address, address regexp 'i$' from student;
+-----------+---------------------+
| address | address regexp 'i$' |
+-----------+---------------------+
| BeiJing | 0 |
| TianJin | 0 |
| ZhuHai | 1 |
| ShangHai | 1 |
| ShenZhen | 0 |
| GuangZhou | 0 |
+-----------+---------------------+
6 rows in set (0.00 sec)
# regexp关键字,查找含有“i”的address
mysql> select address, address regexp 'i' from student;
+-----------+--------------------+
| address | address regexp 'i' |
+-----------+--------------------+
| BeiJing | 1 |
| TianJin | 1 |
| ZhuHai | 1 |
| ShangHai | 1 |
| ShenZhen | 0 |
| GuangZhou | 0 |
+-----------+--------------------+
6 rows in set (0.00 sec)
mysql>