IPV4STRTOINT
Function | IPV4STRTOINT |
|---|---|
Action | Converts an IPv4 address into an integer. |
Parameters | (string) IPv4 Address in print notation, for example "10.20.30.45" |
Return values | (integer) The IPv4 Address represented as an integer, for example 169090605 = (256^3 * 10) + (256^2 * 20)+ (256 * 30) +(45) |
Examples | // Input is "10.20.30.45"
// Returns 169090605
SELECT IPV4STRTOINT("10.20.30.45") AS Integer; |
Notes | This function is useful when comparing IP Addresses. Does not support IPv6. |