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)