I did not know of Sphynx… it seems as a good (extra) solution to my problem.
I want to do something similar to the search on yelp.com or as is specified here.
At this time I’m using MySQL 4.1 and the following query:
SELECT SQL_CALC_FOUND_ROWS entries.*
JOIN geolocations ON (entries.id = geolocations.entry_id)
( geolocations.wgs84_lat BETWEEN 55.9920055076675 AND 57.0005291105997 ) AND
( geolocations.wgs84_lon BETWEEN 3.55064105987549 AND 3.57124042510986 ) AND
MATCH (name) AGAINST (‘+name*’ IN BOOLEAN MODE)
ORDER BY score DESC
LIMIT 0, 8;
I also tried putting lat and lng in the entries table…but that was not helping very much…
Great forum BTW! Seems to be much more active than the original MySQL forum…