mysql json及xml查询

SELECT * FROM `pay_batch_order` a WHERE json_extract(a.`orderInfo`,"$.toAccountNo")='90002019022700001'

posted @ 2020-04-17 10:33  windy1012  阅读(392)  评论(0)  编辑  收藏  举报