MySQL查询替换列值中的特殊字符
让我们首先创建一个表-
create table DemoTable1574 -> ( -> StudentCode varchar(20) -> );
使用插入命令在表中插入一些记录-
insert into DemoTable1574 values('111_Carol');
insert into DemoTable1574 values('______');
insert into DemoTable1574 values('David_12345');
insert into DemoTable1574 values('______');使用select语句显示表中的所有记录-
select * from DemoTable1574;
这将产生以下输出-
+-------------+ | StudentCode | +-------------+ | 111_Carol | | ______ | | David_12345 | | ______ | +-------------+ 4 rows in set (0.00 sec)
这是要替换的查询-
update DemoTable1574 set StudentCode=replace(StudentCode,'______','Mike_007'); Rows matched: 4 Changed: 2 Warnings: 0
让我们再次检查表记录-
select * from DemoTable1574;
这将产生以下输出-
+-------------+ | StudentCode | +-------------+ | 111_Carol | | Mike_007 | | David_12345 | | Mike_007 | +-------------+ 4 rows in set (0.00 sec)