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]
