mysql语句where后多个条件吗_mybatis 语句中where 后边要跟必要条件和多个选择条件处理方法...

SELECT

r.node_one as nodeOne,

r.node_two as nodeTwo,

r.relation as relation,

r.is_delete as isDelete,

r.create_time as createTime,

n.model_name as nodeTwoName

FROM relation r LEFT JOIN node n on r.node_two = n.id

r.node_two = #{keyWord} OR

n.model_name LIKE '%${keyWord}%' OR

r.relation LIKE '%${keyWord}%'

group by r.node_one,r.node_two

having r.is_delete = 0 and r.node_one=#{nodeId1}

选择条件可以用标签，必要条件，可以group by 分组之后 写在 having 后边