dongshi9407 2018-10-27 04:12
浏览 56

查询lat long没有返回任何结果mysql

I have this table.

wppl_friends_locator

The table have columns named

lat float(10,6)

long float(10,6)

These columns have lat and long saved of entries, now i am trying to get results within radius of 30 miles from a given lat,long.

Sql does not return any results for some reasons which i am unable to figure out, below is the sql

SELECT
    member_id,
    (3959 * ACOS(
        COS(RADIANS(-19.943379)) *
        COS(RADIANS('lat')) *
        COS(RADIANS('long') - RADIANS(-43.9521885)) +
        SIN(RADIANS(-19.943379)) *
        SIN(RADIANS('lat'))
    )) AS distance
FROM
    wppl_friends_locator
HAVING
    distance < 30
ORDER BY
    distance;

so even if i do an entry in this table with same lat long which I am providing in sql query, It still does not return any results.

I have been stuck on it for few days, any help would be appreciated.

Table structure Table structure

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 AT89C51控制8位八段数码管显示时钟。
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 下图接收小电路,谁知道原理
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度
    • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
    • ¥15 ETLCloud 处理json多层级问题