mysql - 在 MySQL 数据库上操作字符串
问题描述
我有这些字符串:X322-1-381128
和X322-1-383128
我需要操纵这些字符串以获得输出:
X322138128
和X322138328
我试过这个解决方案没有成功,因为输出只有:X322138128
请问你能帮我吗?
mysql> SELECT
'X322-1-381128' string,
SUBSTRING_INDEX('X322-1-381128', '-', 1) a,
SUBSTRING('X322-1-381128', 6, 1) b,
SUBSTRING('X322-1-381128', 8, 2) c,
SUBSTRING('X322-1-381128' ,- 3) d,
CONCAT(
SUBSTRING_INDEX('X322-1-381128', '-', 1),
SUBSTRING('X322-1-381128', 6, 1),
SUBSTRING('X322-1-381128', 8, 2),
SUBSTRING('X322-1-381128' ,- 3)
) output,
'X322-1-383128' string,
SUBSTRING_INDEX('X322-1-381128', '-', 1) a,
SUBSTRING('X322-1-381128', 6, 1) b,
SUBSTRING('X322-1-381128', 8, 2) c,
SUBSTRING('X322-1-381128' ,- 3) d,
CONCAT(
SUBSTRING_INDEX('X322-1-383128', '-', 1),
SUBSTRING('X322-1-383128', 6, 1),
SUBSTRING('X322-1-383128', 8, 2),
SUBSTRING('X322-1-383128' ,- 3)
) output;
+---------------+------+---+----+-----+------------+---------------+------+---+----+-----+------------+
| string | a | b | c | d | output | string | a | b | c | d | output |
+---------------+------+---+----+-----+------------+---------------+------+---+----+-----+------------+
| X322-1-381128 | X322 | 1 | 38 | 128 | X322138128 | X322-1-383128 | X322 | 1 | 38 | 128 | X322138128 |
+---------------+------+---+----+-----+------------+---------------+------+---+----+-----+------------+
1 row in set
解决方案
使用替换('X322-1-381128','-')
推荐阅读
- node.js - Next.js 的 API 路由不发送响应
- android - Facebook 受众网络一直等待广告请求
- c++ - C ++中的短无符号整数
- asp.net-core - Chrome 手机颜色不匹配
- php - 根据状态隐藏记录
- vba - 允许从一个表中删除数据以添加到另一个表
- sql - 带有 LEFT JOIN、GROUP BY 和 HAVING 的 SQL UPDATE 语句?
- flutter - 尝试在 Flutter FutureBuilder 中构建 ListView 时出错
- swift - 如何在 SwiftUI 中交换 TabView 和 BottomToolbar
- sql - 将时间戳转换为 varchar