MySQL查询从一列到另一列中分离并选择字符串值（带连字符）
为此，您可以使用SUBSTRING_INDEX()。让我们首先创建一个表-
mysql> create table DemoTable1962 ( EmployeeInformation text );
使用插入命令在表中插入一些记录-
mysql> insert into DemoTable1962 values('101-John-29');
mysql> insert into DemoTable1962 values('102-David-35');
mysql> insert into DemoTable1962 values('103-Chris-28');使用select语句显示表中的所有记录-
mysql> select * from DemoTable1962;
这将产生以下输出-
+---------------------+ | EmployeeInformation | +---------------------+ | 101-John-29 | | 102-David-35 | | 103-Chris-28 | +---------------------+ 3 rows in set (0.00 sec)
这是从一列到不同列中分离和选择值的查询-
mysql> select substring_index(EmployeeInformation, '-', 1) as EmployeeId, substring_index(substring_index(EmployeeInformation,'-',2),'-',-1) AS EmployeeName, substring_index(substring_index(EmployeeInformation,'-',-2),'-',-1) AS EmployeeAge from DemoTable1962;
这将产生以下输出-
+------------+--------------+-------------+ | EmployeeId | EmployeeName | EmployeeAge | +------------+--------------+-------------+ | 101 | John | 29 | | 102 | David | 35 | | 103 | Chris | 28 | +------------+--------------+-------------+ 3 rows in set (0.00 sec)