订单表中room字段中有一条记录是这样子：
[{"room_id": 22, "roomName": "306号房间"}, {"room_id": 24, "roomName": "308号房间"}] [{"room_id": 22, "r
[{"room_id": 22, "roomName": "306号房间"}, {"room_id": 24, "roomName": "308号房间"}] [{"room_id": 22, "r
阅读背景：
mysql的JSON字段查询
来源：互联网
分享到：
