SQL data conversion help

[kh99]

Originally Posted by WorldCraft

This function is converting the values from the ip column into hexadecimal, then converting that to base 10, then converting that into an IPv4 address. Correct?

Right. In case you haven't found it (or something similar), there's an online MySQL manual with a function reference here: http://dev.mysql.com/doc/refman/5.0/en/functions.html

Also, could you explain why the original values in the column do not appear as UNHEX'd? It seems that the only two that appear to be UNHEX'd are #s 2 and 9 in the column.

To be honest, I'm not an SQL expert or anything, but I like figuring out stuff like that. So I don't know the answer for sure, but my guess would be this: that column is just 4 bytes (one representing each section of an ip address), and whatever program you use to display that column (phpMyAdmin or whatever) displays it as a 4 character text string if all the bytes in the string happen to represent printable characters, otherwise it shows it as hexadecimal.