Here is a nifty trick I found to return a nice looking IP format such as 10.0.3.1 rather than 010.000.003.001
this query returns the formatted ip, and can easily be substituted into the query page
[code]SELECT *,INET_NTOA(INET_ATON(net_ip_address)) as formatted_ip FROM `system`[/code]
and then instead of using net_ip_address you can use formatted_ip
so taking a previous example of a custom query I made
[code]SELECT * FROM `system` WHERE `system_memory` < 384[/code]
and adding in the formatted address you get
[code] SELECT *,INET_NTOA(INET_ATON(net_ip_address)) as formatted_ip FROM `system` WHERE `system_memory` < 384[/code]
|