获取某个经纬度附近3公里的商户

东二环泰禾广场
五四北泰禾广场
仓山万达广场   
台江万达广场  
白湖亭万达广场  
宝龙城市广场   
恒力城mall  
华润万象城
奥特莱斯广场
苏宁广场
东百中心
东百元洪城

SELECT *,'东二环泰禾广场'  as cityname FROM tb_merchant WHERE ST_Distance_Sphere(point(longitude, latityde), point( 119.33595,26.08979)) <= 3000;
union
SELECT *,'五四北泰禾广场'  as cityname FROM tb_merchant WHERE ST_Distance_Sphere(point(longitude, latityde), point(119.32467,26.13972)) <= 3000;
union
SELECT *,'仓山万达广场'  as cityname FROM tb_merchant WHERE ST_Distance_Sphere(point(longitude, latityde), point(119.27385,26.03579)) <= 3000;
union
SELECT *,'台江万达广场'  as cityname FROM tb_merchant WHERE ST_Distance_Sphere(point(longitude, latityde), point(119.34219,26.05321)) <= 3000;
union
SELECT *,'白湖亭万达广场'  as cityname FROM tb_merchant WHERE ST_Distance_Sphere(point(longitude, latityde), point(119.33445,26.03873)) <= 3000;
union
SELECT *,'宝龙城市广场'  as cityname FROM tb_merchant WHERE ST_Distance_Sphere(point(longitude, latityde), point(119.29171,26.06145)) <= 3000;
union
SELECT *,'恒力城mall'  as cityname FROM tb_merchant WHERE ST_Distance_Sphere(point(longitude, latityde), point(119.30559,26.09100)) <= 3000;
union
SELECT *,'华润万象城'  as cityname FROM tb_merchant WHERE ST_Distance_Sphere(point(longitude, latityde), point(119.27709,26.07482)) <= 3000;
union
SELECT *,'奥特莱斯广场'  as cityname FROM tb_merchant WHERE ST_Distance_Sphere(point(longitude, latityde), point(119.40933,26.24107)) <= 3000;
union
SELECT *,'苏宁广场'  as cityname FROM tb_merchant WHERE ST_Distance_Sphere(point(longitude, latityde), point(119.28778,26.06049)) <= 3000;
union
SELECT *,'东百中心'  as cityname FROM tb_merchant WHERE ST_Distance_Sphere(point(longitude, latityde), point(119.29884,26.08479)) <= 3000;
union
SELECT *,'东百元洪城'  as cityname FROM tb_merchant WHERE ST_Distance_Sphere(point(longitude, latityde), point(119.31627,26.05215)) <= 3000;