As a complement of MySQL – IP To Numeric Value, here is how to convert IP to numeric value using PHP.
int ip2long ( string $ip_address )
printf(“%u\n”,ip2long(“209.207.224.40″));//return 3520061480.
To convert numeric value to IP:
string long2ip ( int $proper_address )
long2ip(3520061480);//return 209.207.224.40
Because PHP’s integer type is signed, and many IP addresses will result in negative integers, you need to [...]

So you want to convert the ip ‘209.207.224.40′ to 3520061480 using mysql while 3520061480 comes from 209*2563 + 207*2562 + 224*256 + 40.
You can use INET_ATON(expr) function.
SELECT INET_ATON(‘209.207.224.40′)
And vice-versa if you want to convert number to ip you can use INET_NTOA(expr) function.
SELECT INET_NTOA(3520061480)