By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 2 Duplicates: 0 Warnings: 0
Rows matched: 2 Changed: 2 Warnings: 0
| json_data |
|---|
| { "company": { "id": "", "name": "", "address": "" }, "info_company": { "diff_v": "<50%", "grav_v": "", "diff_s": "<50%", "grav_s": "", "diff_g": ">50%", "grav_g": "", "diff_ri": ">50%", "grav_ri": "<50%" } } |
| { "company": { "id": "", "name": "", "address": "" }, "info_company": { "diff_v": ">50%", "grav_v": "", "diff_s": "<50%", "grav_s": "", "diff_g": "<50%", "grav_g": "", "diff_ri": ">50%", "grav_ri": ">50%" } } |
| regex12 | regex34 |
|---|---|
| ((?:"diff_v"|"grav_v"|"diff_s"|"grav_s"|"diff_g"|"grav_g"|"diff_ri"|"grav_ri")\s*:\s*)"([12])" | ((?:"diff_v"|"grav_v"|"diff_s"|"grav_s"|"diff_g"|"grav_g"|"diff_ri"|"grav_ri")\s*:\s*)"([34])" |