mysql8 sql regexp_replace 构建map字符串，同key取值value

 

字符串：   

set str = "123:456,222:444,2222:333,555:7677,";

通过key取值：

key=222

select regexp_replace(str,'(.*,)?222:([[:digit:]]+)(,.*)?','$2');

通过 value取key

value = 333

select regexp_replace(str,'(.*,)?([[:digit:]]+):333(,.*)?','$2');

 

 

实例：https://blog.csdn.net/hai2653068/article/details/103549823