MySQL 简单表的搜索功能实现。
<select id="getSiteListByKeyword" parameterType="java.lang.String" resultMap="BaseResultMap">
select
<include refid="Base_Column_List"></include>
from 59_site
where keywords like concat('%',#{keyword},'%')
or site_name like concat('%',#{keyword},'%')
limit 20
</select>