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.