mysql FUNCTION 存储。ST_Intersects 不存在

Question

我正在尝试设置一个值 isInside ，就好像用户地理位置位于表内的任何形状之一内，我正在执行此查询

function getNearMe( $lat = 0 , $lng = 0  , $withDistance = 120)
{

   try{ 
         $q = $this->api->pdo->prepare("SELECT * ,
                                        ( 3959 * acos( cos( radians($lat) ) * cos( radians( store_latitude ) ) * cos( radians( store_longitude ) - radians($lng) ) + 
                                        sin( radians($lat) ) *
                                         sin( radians( store_latitude ) ) ) ) AS distance,
                                         ST_Intersects(Point($lng,$lat),`gps`)  AS isInside
                                        FROM stores 
                                        " . ( $withDistance == 0 ? "" : " HAVING distance < $withDistance " ) ." 
                                        ORDER BY distance
                                        ");

          $q->execute();

          return $q->fetchAll( PDO::FETCH_ASSOC );

       }catch( PDOException $e ){
        print_r($e);
       return array();
    }
}

ST_Intersects(Point($lng,$lat),gps) AS isInside

这是表格

但我收到此错误:

FUNCTION stores.ST_Intersects does not exist

Answer 1

我发现该解决方案可能对其他人有帮助

MBRContains(gps,
GeomFromText('Point($lat $lng)')) AS isInside