You could try using CONCAT:
select distinct(CONCAT(lat, long)) from table where ...
Steve Musumeche
CIO, Internet Retail Connection
steve@stripped
Brian Dunning wrote:
> Lat & lon are two different fields. Either can be duplicated, but not
> both.
>
>
> On Sep 12, 2006, at 12:33 PM, Steve Musumeche wrote:
>
>> Select DISTINCT(lat_long_field) from table where...
>>
>> Steve Musumeche
>> CIO, Internet Retail Connection
>> steve@stripped
>>
>>
>>
>> Brian Dunning wrote:
>>> 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=1
>>>>
>>>
>>>
>>> --MySQL General Mailing List
>>> For list archives: http://lists.mysql.com/mysql
>>> To unsubscribe:
>>> http://lists.mysql.com/mysql?unsub=1
>>>
>>>
>>
>> --MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=1
>>
>
>
> --MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
