SELECT U.*, H.NAME AS HALL_TYPE_NAME FROM T_HALL U LEFT JOIN T_HALL_TYPE H ON U.HALL_TYPE_ID = H.ID WHERE
1=1
<if test="name != ''">
and U.NAME like '%'|| #{name}||'%'
</if>
ORDER BY U.ID DESC
1=1
<if test="name != ''">
and U.NAME like '%'|| #{name}||'%'
</if>
ORDER BY U.ID DESC