MySQL查询删除列记录中除最后7个字符外的所有内容
让我们首先创建一个表-
create table DemoTable ( Strength text );
使用插入命令在表中插入一些记录-
insert into DemoTable values('John is a good programmer');
insert into DemoTable values('Chris is a good player in cricket');
insert into DemoTable values('Bob is good in algorithm');使用select语句显示表中的所有记录-
select *from DemoTable
这将产生以下输出-
+-----------------------------------+ | Strength | +-----------------------------------+ | John is a good programmer | | Chris is a good player in cricket | | Bob is good in algorithm | +-----------------------------------+ 3 rows in set (0.00 sec)
以下是删除列记录中最后7个字符以外的所有内容的查询-
update DemoTable set Strength=substr(Strength,-7,7); Rows matched: 3 Changed: 3 Warnings: 0
让我们再次检查表记录-
select *from DemoTable;
这将产生以下输出-
+----------+ | Strength | +----------+ | grammer | | cricket | | gorithm | +----------+ 3 rows in set (0.00 sec)