mysql 字段内JSON节点查询

举例，user 表有个 phone_numbers 字段，字段内储存数据格式为 {"cnPhone":"123","usPhone":"234","frPhone":"345"}
如果我们需要查询 cnPhone 为 123 并且usPhone 为 234 的用户sql 可以这样写

SELECT *
FROM user                                                                                                                                                                                                                                          
WHERE JSON_UNQUOTE(JSON_EXTRACT(phone_numbers, '$.cnPhone')) = '123' 
and JSON_UNQUOTE(JSON_EXTRACT(phone_numbers, '$.usPhone')) = '234' ;