add remove language chart show hidden hide
db<>fiddle
donate feedback about
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])"