使用substr + SUBSTR MYSQL

Question

我有一个字符串：

Result":{"CreateDate":"2021-05-27T19:58:33","OrderKey":"6ea1eb40-bd80-4e8b-8e78-a7 ","OrderReference":"app_iheillyy_9816617_AF_e2002"}}

然后我需要提取"OrderKey"之后的位置和一些位置

接下来是：OrderKey":"6ea1eb40-bd80-4e8b-8e78-a7 "，

可能有两个或更多的功能？

Answer 1

您可以像这样使用SUBSTRING_INDEX和CONCAT：

SET @mystr := 'Result":{"CreateDate":"2021-05-27T19:58:33","OrderKey":"6ea1eb40-bd80-4e8b-8e78-a7 ","OrderReference":"app_iheillyy_9816617_AF_e2002"}}"';

SELECT
CONCAT('"OrderKey',
SUBSTRING_INDEX(
SUBSTRING_INDEX(@mystr, "OrderKey", -1), ",", 1)) ;

示例

MariaDB [bernd]> SET @mystr := 'Result":{"CreateDate":"2021-05-27T19:58:33","OrderKey":"6ea1eb40-bd80-4e8b-8e78-a7 ","OrderReference":"app_iheillyy_9816617_AF_e2002"}}"';
Query OK, 0 rows affected (0.00 sec)

MariaDB [bernd]> 
MariaDB [bernd]> SELECT
    -> CONCAT('"OrderKey',
    -> SUBSTRING_INDEX(
    -> SUBSTRING_INDEX(@mystr, "OrderKey", -1), ",", 1)) ;
+----------------------------------------------------------------------------------------+
| CONCAT('"OrderKey',
SUBSTRING_INDEX(
SUBSTRING_INDEX(@mystr, "OrderKey", -1), ",", 1)) |
+----------------------------------------------------------------------------------------+
| "OrderKey":"6ea1eb40-bd80-4e8b-8e78-a7 "                                               |
+----------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [bernd]>