On Tue, 27 Dec 2005 23:25:37 +0200, Eugene <evgenius@xxxxxx> wrote: >SELECT * FROM ipdb2 WHERE '3229285376' BETWEEN ipfrom AND ipto; If your [ipfrom, ipto] ranges are non-overlapping, you might be able to exploit that fact by adding something like ... ORDER BY ipfrom DESC LIMIT 1 Servus Manfred
