Mysql unicode编码内容的查询
表中data字段存储的内容,此处为unicode编码:
{"OBJECTID": 10, "\u540d\u79f0": "261\u5f04\u793e\u533a\u536b\u751f\u670d\u52a1\u7ad9", "esriGeometryPoint": {"latitude": 31.31485430122142, "system": "wgs84", "longitude": 121.45822794140372}, "\u5730\u5740": "\u9633\u6cc9\u8def345\u5f0420\u53f7102\u5ba4", "smallCategory": "\u533b\u9662", "\u6240\u5c5e\u533a\u53bf": "\u9759\u5b89\u533a", "\u5c5e\u6027": " ", "largeCategory": "\u533b\u9662", "originGeoLocation": "{\"y\": 8803.557495117188, \"x\": -849.1373291015625}"}
编码转换后的内容:
{
"OBJECTID":10,
"名称":"261弄社区卫生服务站",
"esriGeometryPoint":{
"latitude":31.31485430122142,
"system":"wgs84",
"longitude":121.45822794140372
},
"地址":"阳泉路345弄20号102室",
"smallCategory":"医院",
"所属区县":"静安区",
"属性":" ",
"largeCategory":"医院",
"originGeoLocation":"{"y": 8803.557495117188, "x": -849.1373291015625}"
}
现在查询data中出现“静安区”的数据,sql语句为:
SELECT * FROM arcgis_message WHERE `data` LIKE CONCAT('%','_u9759_u5b89_u533a','%');