two column having ip address stored.each row having a range(ip_address_to,ip_address_from,country) and country mapping to which the ip belongs. Question was wat will be the best structure to store it in sql as well as how to optimize it if queried such a table.
Anonymous
store ip address in long datatype column.have indexes in them
Check out your Company Bowl for anonymous work chats.