找出附近距离自己最近的店家

SELECT USER_CODE,SHOP_NAME,ROUND(6378.138*2*ASIN(SQRT(POW(SIN((#{lat}*PI()/180-SUBSTR(POSITION,LOCATE(',',POSITION) + 1)*PI()/180)/2),2)+COS(#{lat}*PI()/180)*COS(SUBSTR(POSITION,LOCATE(',',POSITION) + 1)*PI()/180)*POW(SIN((#{lng}*PI()/180-SUBSTR(POSITION,1,LOCATE(',',POSITION) - 1)*PI()/180)/2),2)))*1000) AS distance  FROM  (SELECTUSER_CODE,SHOP_NAME,POSITIONFROM jk_user_infoWHERE USER_TYPE = 'normal' ANDSTATUS = 1 AND AUDIT_STATUS = 2 ANDMBRContains (PolygonFromText (CONCAT('Polygon((',REPLACE (REPLACE (SEND_RANGE, ',',' '),'|',','),',',REPLACE (SUBSTR(SEND_RANGE,1,LOCATE('|', SEND_RANGE) - 1),',',' '),'))')),PolygonFromText (concat('Point(',REPLACE (#{position},',',' '),')'))) >0 )AS bsORDER BY distance ASC LIMIT 1