SELECT *
FROM your_table
WHERE ST_Distance_Sphere(geom, ST_GeomFromText(POINT(112.557553 37.860407))) < 1.0;
geom 为数据库存存经纬度的字段,数据库存的为字符串格式,样式为POINT(112.557553 37.860407)
SELECT *
FROM your_table
WHERE ST_Distance_Sphere(geom, ST_GeomFromText(POINT(112.557553 37.860407))) < 1.0;
geom 为数据库存存经纬度的字段,数据库存的为字符串格式,样式为POINT(112.557553 37.860407)