Is there MySQL version of ip2long()?

[yurko]

I have table where I store IPs in format
184.34.122.32 now I want it to store ip in integer format. I wanderif that is possible with MySQL. Something like:
update mytable set ip_field = ip2long(ip_field);
Thank you in advance.

[bastien]

function ip2long()
{
//split the ip into pieces
$ip = explode(".",$ip_field);
//count the number of pieces
$q=count($ip);
//create a loop to concatenate the pieces
for ($i=0;$i<=$q;$i++){
if ($i=0){
$your_ip = $ip(0);
}else{
$your_ip .=$ip(i);
}
//show the ip with no '.'
echo $your_ip;
}

hth

bastien

[yurko]

Thanx for answer but I dont need PHP implementation of ip2long(). Im looking if there is mysql function with same result.
To use in SQL statements. Like:
"SELECT thefunction( my_ip_field) FROM my_table" in my_ip_field is stored something like "152.34.32.12" and output should be
like: "-23423445456". Ehh.. I think there is no such a mysql function...