mysql查询json字段内属性

两条数据的instance_id和json：
1544934805590097921
{
“1544858400449740802”: “192.168.0.1”,
“1544859614050631681”: “192.168.0.1”,
“1544883963344306178”: “未监测”
}

1544934964273201153
{
“1544864900727554049”: “test”,
“1544865021708058625”: “test”,
“1544865147423932417”: “已上线”,
“1544883963344306178”: “已监测”
}

使用方式：
SELECt json字段名 -> '$."json内属性的key"' as 别名
        FROM 表名
        WHERe instance_id = id
sql实例：
SELECt json -> '$."1544858400449740802"' as ip
        FROM sys_instance
        WHERe instance_id = 1544934805590097921

该查询语句在java的mapper中的写法：

        
        
        
    
//instanceMap为instance对象和instance表的映射

        SELECT json -> '$."${ipKey}"' as ip
        FROM sys_instance
        WHERe instance_id = #{instanceId}
    

查询结果：

SELECT *
FROM sys_instance
WHERe json -> '$."1544858400449740802"' = '192.168.0.1'		

该查询语句在java的mapper中的写法：

SELECT *
FROM sys_instance
WHERe json -> '$."${ipKey}"' =#{ip} 	

查询结果：