Reichhart Consulting

I find that I need to do this frequently, but not quite frequently enough to remember it…

http://www.xaprb.com/blog/2006/10/11/how-to-delete-duplicate-rows-with-sql/

This query will return all networks that a given IP could belong to, assuming the table contains the network address [varchar(15)] and prefix [smallint(5)].

SELECT concat(network_address,’/',prefix) network
FROM networks
WHERE network_address = inet_ntoa(
INET_ATON(’10.10.0.123′) &
(0xFFFFFFFF << 32 – prefix & 0xFFFFFFFF))
ORDER BY INET_ATON(network_address);

Click on “Design” in the upper right corner of the screen
Click on “Edit HTML”
Scroll down (way down) until you find the “</head>” tag
Add these two lines:
<link href=’http://www.yoursite.com/favicon.ico’ rel=’shortcut icon’/>
<link href=’http://www.yoursite.com/favicon.ico’ rel=’icon’/>