很多時候mysql的一列當中存的是json格式的數據，這時候如果要查詢某個key對應的值的時候要如何查詢呢，這里記錄一種查詢方法：

json列的值：
{“InventoryMainTypeCode”: 1, “InventoryMainTypeName”: “GOOD”}

現在要查詢InventoryMainTypeCode為xxx或者InventoryMainTypeName為xxx的數據：（這里以springboot+mybatis為例子）

代碼：
請求類：

Query query = new Query();

@Data
public class Query implements Serializable {private Map<String, Object> featureMap = new HashMap<>();public void setFeature(String feature) {if (StringUtils.isNotBlank(feature)) {featureMap = JSON.parseObject(feature, Map.class);}}public void addFeature(String key, Object value) {if (StringUtils.isBlank(key)) {return;}this.featureMap.put(key, value);}public void addFeatureMap(Map<String, Object> featureMaps) {if (MapUtils.isNotEmpty(featureMaps)){this.featureMap.putAll(featureMaps);}}
}

在代碼中將key添加到Feature中：

query.addFeature(DicConst.InventoryMainTypeCode.name(), 1);
List<ResultDTO> dTOS = dictionaryManager.queryDicByParam(query);

mapper文件：

 List<CnbDictionaryDO> queryDicByParam(CnbDictionaryQuery query);

xml:

  <select id="queryDicByParam" resultMap="BaseResultMap">select<include refid="Base_Column_List"/>from<include refid="Table_Name"/><where><if test="id != null">and id = #{id}</if><if test="featureMap != null and featureMap.size > 0"><foreach collection="featureMap" index="key" item="value"><if test="value != null"><![CDATA[and feature->'$.${key}' = #{value}]]></if></foreach></if></where></select>