my $point = "POINT( $data{'lng'} $data{'lat'} )"; my $query = $dbh->prepare("SELECT idUSRN FROM USRN WHERE idUSRN > 0 ORDER BY ST_Distance_Sphere( ST_GeomFromText( ?, 4326 ), center ) LIMIT 10"); $query->execute($point); my $usrn = $query->fetchrow_array;