Evan Borgstrom wrote:
The same way the kernel deals with them; int(10) unsigned. To convert a dotted quad string into int(10) use the following:Using 192.168.10.50: 192 + (168 * 2^8) + (10 * 2^16) + (50 * 2^24) = 839559360 This is real handy if you're doing low level socket stuff and storing addresses in the database. -Evan
This is how I've stored IP information in the past. It also makes it much easier to sort by IP, etc. However I believe you mean
(192 * 2^24) + (168 * 2^16) + (10 * 2^8) + 50 = 3232238130 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
