mybatis-plus如何操作json字段

CREATE TABLE `demo` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `tag` json DEFAULT NULL,
  PRIMARY KEY (`id`)
)

select * from demo where json_contains(tag,'"a"');
id|tag            |
--+---------------+
 3|["a", "b", "c"]|

select json_search(‘{“a”:“xyzf”,“b”:{“c”:“sdf”}}',‘all',‘%f%')

select * from doc where json_search(tag,‘all',‘%d%')

@TableName(value="doc",autoResultMap = true)

@TableName(value="doc",autoResultMap = true)
public class Doc{
    @TableField(value="tag",typeHandler = FastjsonTypeHandler.class)
    private Set<String> tag;
}   

QueryWrapper<Doc> wrapper = new QueryWrapper<>();
wrapper.isNotNull("json_search(tag,'all',concat('%','" + param.getTag() + "','%'))");

<resultMap id="resourceMap" type="com.demo.common.params.response.Resource" autoMapping="true" >
    <result column="tag" jdbcType="JAVA_OBJECT" property="tag" typeHandler="com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler" javaType="java.util.ArrayList"/>
</resultMap>
<select id="pageOfSearchKey" resultMap="resourceMap"
            parameterType="com.demo.common.params.request.doc.DocPageParam">
    select * from doc where json_search(tag,'all',concat('%',#{param.searchKey},'%'))
</select>

<update id="addTag" parameterType="com.demo.common.params.request.doc.DocTagParam">
    update doc set tag =json_Array_append(tag,'$',#{param.tag}) , update_time=update_time
    where
    doc_no in
    <foreach collection="param.docNoList" item="docNo" open="(" separator="," close=")">
        #{docNo}
    </foreach>
    and !JSON_CONTAINS(tag,concat('"',#{param.tag},'"'))
</update>

    <update id="removeTag">
        UPDATE doc SET tag = JSON_REMOVE(tag, JSON_UNQUOTE(JSON_SEARCH(tag, 'all', #{param.tag}))) WHERE
        JSON_SEARCH(tag, 'all',#{param.tag})
        and doc_no in
        <foreach collection="param.docNoList" item="docNo" open="(" separator="," close=")">
            #{docNo}
        </foreach>
    </update>