MySQL中获取列的子字符串

使用SUBSTR()方法获取列的子字符串。

让我们首先创建一个表-

create table DemoTable -> ( -> Title text -> );

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

insert into DemoTable values(This is a MySQL Database); insert into DemoTable values(Java is an Object Oriented Programming Language);

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

select *from DemoTable ;

输出结果

这将产生以下输出-

+-------------------------------------------------+ | Title | +-------------------------------------------------+ | This is a MySQL Database | | Java is an Object Oriented Programming Language | +-------------------------------------------------+ 2 rows in set (0.00 sec)

这是选择列子串的查询-

SELECT distinct(substr(Title, 1, 8)) from DemoTable;

输出结果

这将产生以下输出-

+-----------------------+ | (substr(Title, 1, 8)) | +-----------------------+ | This is | | Java is | +-----------------------+ 2 rows in set (0.00 sec)