List:General Discussion« Previous MessageNext Message »
From:Brian Dunning Date:September 12 2006 7:22pm
Subject:Re: Distinct select over 2 fields?
View as plain text  
Many different records will be returned though, I just don't want any  
dupes where both lat/lon is the same.

:)

On Sep 12, 2006, at 12:20 PM, Hiep Nguyen wrote:

> select * from table where ..... limit 1
>
> that would do it if you don't care which one it returns
>
> JC
>
> On Tue, 12 Sep 2006, Brian Dunning wrote:
>
>> I'm searching a database of geopoints, and when two records have the
>> same latitude and longitude, I only want to return one of them -
>> basically just find all the unique locations. How do you set up a
>> select like this? Thanks...
>>
>>
>
> -- 
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql? 
> unsub=brian@stripped
>

Thread
Distinct select over 2 fields?Brian Dunning12 Sep
  • Re: Distinct select over 2 fields?Hiep Nguyen12 Sep
    • Re: Distinct select over 2 fields?Brian Dunning12 Sep
      • Re: Distinct select over 2 fields?Steve Musumeche12 Sep
        • Re: Distinct select over 2 fields?Brian Dunning12 Sep
          • Re: Distinct select over 2 fields?Steve Musumeche12 Sep
            • Re: Distinct select over 2 fields?Brian Dunning13 Sep
              • Re: Distinct select over 2 fields?Brian Dunning13 Sep
  • Re: Distinct select over 2 fields?Stuart Brooks13 Sep