对象类型 EQ

queryWrapper
.apply("JSON_UNQUOTE(JSON_EXTRACT(json_obj_column, '$.json_field')) = {0}","value");
1
2

对象类型 IN

queryWrapper
.apply(
"JSON_UNQUOTE(JSON_EXTRACT(json_obj_column, '$.json_field')) IN ('var1','var2','var3')");
1
2
3

数组类型包含

queryWrapper.apply("JSON_CONTAINS(json_arr_column, JSON_ARRAY({0}))", "xxxxx");
//一个数组包含另一个数组
JSON_CONTAINS("[123,321]", JSON_ARRAY(123))
1
2
3

JSON转临时表（8.0以上可用)

SELECT
	* 
FROM
	JSON_TABLE ( '[{"c1":1,"c2":"abc123"},{"c1":2,"c2":"abc124"}]', '$[*]' COLUMNS ( c1 INT PATH '$.c1', c2 VARCHAR ( 100 ) PATH '$.c2' ) ) 
	AS jt;
1
2
3
4
5