Question

mysql5.6版本怎么对json进行截取某个具体的值（需要详解）

{"operation_date":"2017-11-29","customeRegisteredTime":"2017-11-29","occupyTime":"2017-11-29","dataCenters":"--请选择--","rackFloor":"--请选择数据--","roomName":"--请选择数据--","operationTime":"2017-11-29","preholding_racks":"\n\t\t\t\t\t\t\t","preholding_reservation":"\n\t\t\t\t\t\t\t","preholding_server":"\n\t\t\t\t\t\t\t","preholding_band":"\n\t\t\t\t\t\t\t","preholding_ipDress":"\n\t\t\t\t\t\t\t","dealProcessDatas":[]}

{"contractNum":"LNSY1122","operation_date":"2017-11-29","customName":"华为","customeRegisteredTime":"2017-11-29","customManager":"王毅","rackQty":"2","ipQty":"64","bandwidthQty":"2","occupyTime":"2017-11-29","dataCenters":"113680","rackFloor":"--请选择--","roomName":"--请选择--","operationTime":"2017-11-29","preholding_racks":"\n\t\t\t\t\t\t\t","preholding_reservation":"\n\t\t\t\t\t\t\t","preholding_server":"\n\t\t\t\t\t\t\t","preholding_band":"\n\t\t\t\t\t\t\t","preholding_ipDress":"\n\t\t\t\t\t\t\t","dealProcessDatas":[]}
这是表里的两个json 我需要截取customName的字段 而且为自动截取 json 所再表为form_data_info 字段为form_json 求解

Answer 1

MySQL 从5.7才开始支持json类型以及解析。
5.6的话,需要自己实现function去处理json格式的数据，或者针对简答json使用字符串截取函数获取。