INET_ATON() - IP Address String to Number

Q

How to convert an IP address from string format to number using the INET_ATON() function?

✍: FYIcenter.com

A

INET_ATON(ip) is a MySQL built-in function that converts an IP address from string format to number. It uses the following conversion formula:

INET_ATON('p₁.p₂.p₃.p₄') = INET_ATON(p₁×256³ + p₂×256² + p₃×256 + p₄

For example:

SELECT INET_ATON('10.0.5.9'), 10*POW(256,3) + 0*POW(256,2) + 5*256 + 9;
  -- +-----------------------+------------------------------------------+
  -- | INET_ATON('10.0.5.9') | 10*POW(256,3) + 0*POW(256,2) + 5*256 + 9 |
  -- +-----------------------+------------------------------------------+
  -- |             167773449 |                                167773449 |
  -- +-----------------------+------------------------------------------+

SELECT INET_ATON('127.0.0.1'), 127*POW(256,3) + 0*POW(256,2) + 0*256 + 1;
  -- +------------------------+-------------------------------------------+
  -- | INET_ATON('127.0.0.1') | 127*POW(256,3) + 0*POW(256,2) + 0*256 + 1 |
  -- +------------------------+-------------------------------------------+
  -- |             2130706433 |                                2130706433 |
  -- +------------------------+-------------------------------------------+

Reference information of the INET_ATON() function:

INET_ATON(ip): int
  Converts an IP address from string format to number.

Arguments, return value and availability:
  ip: Required. The IP address in string format. 
  int: Return value. The IP address as a number.
  Available since MySQL 4.0.

Related MySQL functions:

⇒ INET_NTOA() - IP Address Number to String

⇐ IFNULL() - Replacing NULL Value

⇑ MySQL Functions for Miscellaneous Purposes

⇑⇑ MySQL Function References

2023-12-19, 1406🔥, 0💬

IS_IPV6() - Detecting IPv6 Address
How to detect an IPv4 Address using the IS_IPV6() function? IS_IPV6(ip) is a MySQL built-in function that returns 1 if the given value is a valid IPv6 address, 0 otherwise. For example: SELECT IS_IPV4('10.0.5.9'), IS_IPV4('10.0.5.256'); -- +---------------------+------- ----------------+-- | IS_IPV4... 2026-01-24, 1621🔥, 0💬

JSON_SCHEMA_VALIDATION_REPORT() - JSON Schema Validation Report
How to generate a validation report of a JSON value against a JSON schema using the JSON_SCHEMA_VALIDATION_REPORT( )function? JSON_SCHEMA_VALIDATION_REPORT( schema,json) is a MySQL built-in function that returns a validation report of a JSON value against a given JSON schema. The report itself is a ... 2024-11-23, 1581🔥, 0💬

JSON_VALUE() - Converting JSON Value
How to convert a JSON value to a given MySQL data type using the JSON_VALUE() function? JSON_VALUE(json, path RETURNING type on_empty on_error) is a MySQL built-in function that converts a JSON value to a given MySQL data type. The input JSON value can be a member of a parent JSON array or object. F... 2024-11-23, 1484🔥, 0💬

IS_IPV4() - Detecting IPv4 Address
How to detect an IPv4 Address using the IS_IPV4() function? IS_IPV4(ip) is a MySQL built-in function that returns 1 if the given value is a valid IPv4 address, 0 otherwise. For example: SELECT IS_IPV4('10.0.5.9'), IS_IPV4('10.0.5.256'); -- +---------------------+------- ----------------+-- | IS_IPV4... 2026-02-02, 1452🔥, 0💬

JSON_TABLE() - Inline Table with JSON Array
How to create an inline table with a JSON Array using the JSON_TABLE() function? JSON_TABLE(json, path COLUMNS (column_list) AS alias) is a MySQL built-in function that creates an inline table by parsing JSON array members. For example: the following statement creates a 1-column table with string me... 2024-11-23, 1435🔥, 0💬

JSON_SCHEMA_VALID() - JSON Schema Validation
How to validate a JSON value against a JSON schema using the JSON_SCHEMA_VALID() function? JSON_SCHEMA_VALID(schema, json) is a MySQL built-in function that validates a JSON value against a given JSON schema. For example: SET @schema = '{ "id": "http://json-schema.org/geo", "$schema": "http://json-s... 2024-11-23, 1416🔥, 0💬

LEAST() - Finding the Least/Minimum Value
How to find the least (minimum) value of a given list of values using the LEAST() function? LEAST(val1, val2, ...) is a MySQL built-in function that returns the least (minimum) value of a given list of values. For example: SELECT LEAST(70, 89, 73, 99, 101, 110, 116, 101, 114); -- +------------------... 2023-12-19, 1328🔥, 0💬

NULLIF() - NULL on Equal Values
How to generate NULL with equal values using the NULLIF() function? NULLIF(val1, val2) is a MySQL built-in function that returns NULL if the first argument equals the second, the first argument otherwise. For example: SELECT NULLIF('yes', 'yes'), NULLIF('yes', 'no'); -- +----------------------+-----. .. 2023-12-19, 1284🔥, 0💬

BIN() - Converting Integer to Binary String
How to convert an integer to a binary string using the BIN() function? BIN(int) is a MySQL built-in function that converts an integer to binary string. For example: SELECT BIN(1), BIN(2), BIN(4), BIN(8), BIN(16), BIN(1024); -- +--------+--------+--------+-- ------+---------+------------- +-- | BIN(1)... 2024-11-23, 1252🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.