MySQL REGEXP关键字

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>

 

转载于:https://www.cnblogs.com/Robotke1/archive/2013/05/02/3054391.html