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, 266🔥, 0💬

JSON_QUOTE() - Quoting JSON String
How to convert a regular character string into a JSON (JavaScript Object Notation) string using the JSON_QUOTE() function? JSON_QUOTE(str) is a MySQL built-in function that converts a regular character string into a JSON string by quoting the string with double quotes. It replaces the double-quote c... 2023-12-10, 331🔥, 0💬

VARIANCE() - Synonym for VAR_POP()
What's the difference between VARIANCE() and VAR_POP() functions? VARIANCE(expr) is a synonym for the VAR_POP(expr) function. Related MySQL functions: VAR_POP() - Population Standard Variance ⇒ Window Functions ⇐ VAR_SAMP() - Sample Standard Variance ⇑ MySQL Functions on Aggregation Groups ⇑⇑ My... 2023-12-01, 331🔥, 0💬

GET_LOCK() - Requesting User Defined Lock
How to request a user defined lock using the GET_LOCK() function? GET_LOCK(lock, timeout) is a MySQL built-in function that tries to obtain a user defined lock within a timeout period. It returns 1 if successful, 0 if failed. For example: SELECT GET_LOCK('MyLock', 60), IS_FREE_LOCK('MyLock'), IS_USE... 2023-12-20, 319🔥, 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, 314🔥, 0💬

SLEEP() - Holding Statement Execution
How to hold the statement execution for some time using the SLEEP() function? SLEEP(sec) is a MySQL built-in function that holds the execution of the current statement for sec seconds. For example: SELECT SYSDATE(), SLEEP(2), SYSDATE(); -- +---------------------+------- ---+---------------------+-- ... 2023-12-19, 303🔥, 0💬

IS_UUID() - Validating UUID String Format
How to validate a UUID (Universal Unique IDentifier) string using the IS_UUID() function? IS_UUID(uuid) is a MySQL built-in function that validates a UUID (Universal Unique IDentifier) string. It only checks if the given UUID is a 32-digit hexadecimal string or not. For example: SELECT IS_UUID('447f... 2023-12-08, 301🔥, 0💬

JSON_PRETTY() - Validating JSON Value
How to encode a JSON (JavaScript Object Notation) value into a pretty-printing string using the JSON_PRETTY() function? JSON_PRETTY(json) is a MySQL built-in function that encodes a JSON (JavaScript Object Notation) value into a pretty-printing string. For example: SELECT JSON_PRETTY('["a",1,{"key1"... 2023-12-10, 285🔥, 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, 284🔥, 0💬

UUID() - Generating UUID String
How to generate a UUID (Universal Unique IDentifier) string using the UUID() function? UUID() is a MySQL built-in function that returns a UUID (Universal Unique IDentifier) string. For example: SELECT UUID(), UUID(); -- +----------------------------- ---------+-------------------- ------------------+... 2023-12-08, 284🔥, 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.