这样的需求能否直接从数据库正则替换

Question

正则数据库sql

Answer 1

mysql> select concat(substring_index("dddtest:4320-iiiii",":",1),":30-",substring_index("dddtest:4320-iiiii",":",-1));
+---------------------------------------------------------------------------------------------------------+
| concat(substring_index("dddtest:4320-iiiii",":",1),":30-",substring_index("dddtest:4320-iiiii",":",-1)) |
+---------------------------------------------------------------------------------------------------------+
| dddtest:30-4320-iiiii                                                                                   |
+---------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Answer 2

不是这样的吧, 按照规则, 表被替换后应该是这样的:
替换前:+---------+---------------------+
| id      | username            |
+---------+---------------------+
|  139377 | aaatest:20-fffff    |
| 4344377 | bbbtest:1-ggggr  |
| 1893377 | cccdtest:31-hhhh |
| 1037377 | dddtest:4320-iiiii |
|  853377 | eeetest:10-kkkkk |
+---------+---------------------+替换后:+---------+---------------------+
| id      | username            |
+---------+---------------------+
|  139377 | aaatest:20-fffff    |
| 4344377 | bbbtest:1-ggggr  |
| 1893377 | cccdtest:30-hhhh |
| 1037377 | dddtest:30-iiiii |
|  853377 | eeetest:10-kkkkk |
+---------+---------------------+