Grouping in REGEXP_SUBSTR() in MySQL 8.x-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Grouping in REGEXP_SUBSTR() in MySQL 8.x

P粉514458863 2024-04-02 11:56:00

468

I'm trying to use a regular expression that I know about, but it doesn't seem to work in MYSQL v8.0. I'm trying to extract the filename (something.txt) from some_str variable. It keeps returning NULL. Not sure what I'm doing wrong in the pattern.

set @some_str = "{'A': 1234, 'fname': 'something.txt'}";
select regexp_substr(@some_str, "\{'\w+':\s+\d+,\s+'\w+':\s+'(.+)'\}") ;
-- should return:  something.txt