要在连字符后拆分列,请使用SUBSTRING_INDEX()方法-select substring_index(yourColumnName,'-',-1) AS anyAliasName from yourTableName;
让我们首先创建一个表-create table DemoTable
-> (
-> StreetName text
-> );
使用插入命令在表中插入一些记录-insert into DemoTable values('Paris Hill St.-CA-83745646') ;
insert into DemoTable values('502 South Armstrong Street-9948443');
使用select语句显示表中的所有记录-select *from DemoTable;
这将产生以下输出-+------------------------------------+
| StreetName |
+------------------------------------+
| Paris Hill St.-CA-83745646 |
| 502 South Armstrong Street-9948443 |
+------------------------------------+
2 rows in set (0.00 sec)
以下是在特定字符后拆分一列的查询-select substring_index(StreetName,'-',-1) AS Split from DemoTable;
这将产生以下输出-+----------+
| Split |
+----------+
| 83745646 |
| 9948443 |
+----------+
2 rows in set (0.00 sec)