微客导航 » 文章资讯 » 如何从MySQL列中的前20个字符之后选择所有字符？

如何从MySQL列中的前20个字符之后选择所有字符？

2024-04-22 16:33:05 408

让我们首先创建一个表-

mysql> create table DemoTable
(
   Title text
);

使用插入命令在表中插入一些记录-

mysql> insert into DemoTable values('C is a good programming language to start');
mysql> insert into DemoTable values('Java is good with data structure and algorithm');
mysql> insert into DemoTable values('Coding is very important');

使用select语句显示表中的所有记录-

mysql> select *from DemoTable;

这将产生以下输出-

+------------------------------------------------+
| Title                                          |
+------------------------------------------------+
| C is a good programming language to start      |
| Java is good with data structure and algorithm |
| Coding is very important                       |
+------------------------------------------------+
3 rows in set (0.00 sec)

以下是查询以选择前20个字符之后的所有字符-

mysql> select substring(Title from 20) from DemoTable;

这将产生以下输出-

+-----------------------------+
| substring(Title from 20)    |
+-----------------------------+
| ming language to start      |
| ata structure and algorithm |
| rtant                       |
+-----------------------------+
3 rows in set (0.00 sec)

返回顶部
3162201930
czq8825@qq.com

如何从MySQL列中的前20个字符之后选择所有字符？

热门推荐

随机推荐