mysql - 我如何在 MySQL 中订购此 SELECT 语句？

Question

cursor.execute("SELECT user_id FROM myapp_location WHERE\
       GLength(LineStringFromWKB(LineString(asbinary(utm), asbinary(PointFromWKB(point(%s, %s)))))) < %s"\
       ,(user_utm_easting, user_utm_northing, 500));

此查询选择距离当前用户 500 英尺以内的用户。我如何根据距离对人们进行排序？ (g长度)。靠近的第一个，最远的最后。

您将如何更改此查询？谢谢。

Answer 1

这是一种方法

SELECT user_id
     , GLength(LineStringFromWKB(LineString(asbinary(utm), asbinary(PointFromWKB(point(%s, %s)))))) as glength
  FROM myapp_location
HAVING glength < %s"
 ORDER BY glength desc