By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| data | REGEXP_SUBSTR(data, '(?<=")[^"]+(?="[^"]*$)') |
|---|---|
| a:3:{s:8:"ref_type";s:4:"user";s:3:"tid";s:18:"TXID17073204182661";s:7:"message";s:19:"3757000431691375718";} |
3757000431691375718 |