Why don't you just use a GROUP BY on lat,long? > You could try using CONCAT: > > select distinct(CONCAT(lat, long)) from table where ... > > Steve Musumeche > CIO, Internet Retail Connection > [EMAIL PROTECTED] > > > > 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 > >> [EMAIL PROTECTED] > >> > >> > >> > >> 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/[EMAIL PROTECTED]
