… KEY UPDATE is very powerful but often forgotten MySQL feature. It was introduced in MySQL 4.1 but I still constantly see… address, number of times particular keyword was searched etc. This functionality also makes it very easy to do incremental single pass… example actually shows one more neat feature of MySQL – inet_aton and inet_ntoa functions which can convert IP address strings to integers…