回答編集履歴
1
出力結果を記載
test
CHANGED
|
@@ -1,5 +1,11 @@
|
|
|
1
1
|
以下で実現できました。
|
|
2
2
|
```
|
|
3
|
-
SELECT REPLACE(SUBSTRING(SUBSTRING_INDEX('123|456|789|101112|131415', '|', 2), CHAR_LENGTH(SUBSTRING_INDEX('123|456|789|101112|131415', '|', 2 - 1)) + 1),
|
|
3
|
+
> SELECT REPLACE(SUBSTRING(SUBSTRING_INDEX('123|456|789|101112|131415', '|', 2), CHAR_LENGTH(SUBSTRING_INDEX('123|456|789|101112|131415', '|', 2 - 1)) + 1),
|
|
4
|
+
-> '|', '');
|
|
5
|
+
+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
6
|
+
| REPLACE(SUBSTRING(SUBSTRING_INDEX('123|456|789|101112|131415', '|', 2), CHAR_LENGTH(SUBSTRING_INDEX('123|456|789|101112|131415', '|', 2 - 1)) + 1),
|
|
4
|
-
'|', '')
|
|
7
|
+
'|', '') |
|
|
8
|
+
+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
9
|
+
| 456 |
|
|
10
|
+
+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
5
11
|
```
|