Interesting.<p>I find it amusing that he went to all the trouble (well, not that much trouble) of using MySQL's spatial database features when the following simple query performed even better:<p><pre><code> SELECT country_code
FROM ip_country
WHERE ip_to >= INET_ATON('%s')
ORDER BY ip_to ASC
LIMIT 1
</code></pre>