您可以在 MySQL Select 语句中允许正则表达式匹配吗?
mysqlmysqli database更新于 2024/1/9 10:53:00
是的，我们可以在 select 语句中进行正则表达式匹配 −
select yourColumnName from yourTableName where yourColumnName regexp '^yourValue';
首先我们创建一个表 −
mysql> create table DemoTable1892 ( FirstName varchar(20) ); Query OK, 0 rows affected (0.00 sec)
使用 insert 插入命令在表中插入一些记录 −
mysql> insert into DemoTable1892 values('John');
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1892 values('Adam');
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1892 values('Jace');
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1892 values('Johny');
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1892 values('Johnson');
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1892 values('Jack');
Query OK, 1 row affected (0.00 sec)
使用 select 语句显示表中的所有记录 −
mysql> select * from DemoTable1892;
这将产生以下输出 −
+-----------+ | FirstName | +-----------+ | John | | Adam | | Jace | | Johny | | Johnson | | Jack | +-----------+ 6 rows in set (0.00 sec)
这是 MySQL 选择语句中正则表达式匹配的查询 −
mysql> select FirstName from DemoTable1892 where FirstName regexp '^Jo';
这将产生以下输出 −
+-----------+ | FirstName | +-----------+ | John | | Johny | | Johnson | +-----------+ 3 rows in set (0.00 sec)
