搜索包含的sql:
<if test="nickName != null">
AND Admin_NickName like CONCAT(CONCAT('%', #{nickName, jdbcType=VARCHAR}),'%')
</if>
距离附近
SELECT lng,lat,
(POWER(MOD(ABS(lng - $lng),360),2) + POWER(ABS(lat - $lat),2)) AS distance
FROM `user_location`
ORDER BY distance LIMIT 100
合并行
select id,group_concat(colour) colour from table1 GROUP BY id
select CONCAT(wtb_students.Studentds_name ) from 将blob类型直接转换成string