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 dupl
Hi,
I have a strange problem. I am running mysqld (5.0.20) on NetBSD 3.0 and
after the startup scripts are complete the mysqld process ramps up to
100% utilization. However this only happens if I make mysql calls from
within the startup scripts.
If I wait until the startup scripts have completed
you have to find the pointer to
> the row using the index, then go to the row. Doing a table scan
> eliminates needing that extra step of the index.
>
> Next time full SHOW CREATE TABLE statements would be useful.
>
> -Sheeri
>
> On 4/11/06, Stuart Brooks <[EMAIL
Hi,
I have been having a hassle getting the index_merge to work as expected
when I am joining 2 tables on MySQL 5.0.19. The following example should
make it clear:
Table A
key1 (primary key)
key2
some_data
Table B
key1 (indexed)
key2 (indexed)
more_data
SELECT a.key1,a.key2,b.more_d
