I have a table of many IP addresses. I'm doing some PHP/JS/AJAX to populate a select box based upon what someone types in a search field. That works great, except that a user can spend a lot of time guessing as to what possible IPs exist.
What I'd like to do now is one of those "google" suggestions thingys where as you type an IP it suggests the DISTINCT possible next numbers in a drop-down <DIV>. So if I had: 192.168.12.[1 .. 254] 192.168.15.[1 .. 254] 192.168.158.[1 .. 254] 172.16.2.[1 .. 254] Then if I typed "1", the suggestions would be: 192.168.12. 192.168.15. 192.168.158. 172.16.2. Then if I typed a "9" next (so I have "19" in the box) the suggestions would be: 192.168.12. 192.168.15. 192.168.158. Skipping forward, if I had "192.168.15" in the box the suggestions should be: 192.168.15. 192.168.158. And so forth... Anyone have any hints or ideas as to how to formulate a SQL query or bunch of queries to get these 'lists' of results? I'd also be okay with it only working on quad boundaries (.) if that is substantially easier. I currently store IPs as INT values for obvious reasons, but there is the handy "INET_NTOA(IP) as niceip" so a HAVING clause should be able to use that I suspect. Thanks, Daevid. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]