mysql 匹配后三位是数字的字段
create table xufang_test
( id int PRIMARY key auto_increment comment ‘学号’,
name varchar(40) comment ‘姓名’);
select * from xufang_test;
insert into xufang_test (id,name)
VALUES
(1,‘aaaaaaa4444’),(2,‘aaaaa333333’),(3,‘aaaaaaa’),
(4,‘aaaa22’);
select * from xufang_test;
select * from xufang_test where name REGEXP ‘.*\d{3}$’;