select
    id,
    knowledge_name,
    knowledge_type,
    member_id,
    kd_ids,
    train_status,
    knowledge_desc,
    is_open,
    is_deleted,
    CREATOR,
    CREATED_TIME,
    MODIFIER,
    MODIFIED_TIME
from
    biz_knowledge_info
where
    is_deleted = 'N'
    << and member_id = :memberId>>
    << and LOCATE(:query ,knowledge_name) >>
    << and train_status = :trainStatus>>
    << and knowledge_type = :knowledgeType>>
order by MODIFIED_TIME