# Storing IP in mySQL table

**URL:** <https://forum.kirupa.com/t/storing-ip-in-mysql-table/125773>\
**Category:** Uncategorized\
**Created:** [October 17, 2004, 2:44pm UTC](https://forum.kirupa.com/t/storing-ip-in-mysql-table/125773 "2004-10-17T14:44:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![samba\_7](https://avatars.discourse-cdn.com/v4/letter/s/bbce88/32.png) [@samba\_7](https://forum.kirupa.com/u/samba_7)\
**Post date:** [October 17, 2004, 2:44pm UTC](https://forum.kirupa.com/t/storing-ip-in-mysql-table/125773/1 "2004-10-17T14:44:28Z")

</div>

Whats the best way to do this ?

curent values are as followed:

Field: ipaddress  
Type: INT  
Length: 15  
Attributes: UNSIGNED  
Null: not null  
Default: 0  
Extra: -

Sam.