Collections:
IS_IPV4() - Detecting IPv4 Address
How to detect an IPv4 Address using the IS_IPV4() function?
✍: FYIcenter.com
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('10.0.5.9') | IS_IPV4('10.0.5.256') |
-- +---------------------+-----------------------+
-- | 1 | 0 |
-- +---------------------+-----------------------+
Reference information of the IS_IPV4() function:
IS_IPV4(ip): boolean
Returns 1 if and only if the argument is a valid IPv4 address.
Arguments, return value and availability:
ip: Required. The IP address to be examined.
boolean: Return value.
1 if and only if the argument is a valid IPv4 address.
Available since MySQL 4.0.
Related MySQL functions:
⇒ IS_IPV4_COMPAT() - IPv4-Compatible IPv6 Address
⇐ IS_FREE_LOCK() - Checking Lock Status
2026-02-02, 3964🔥, 0💬
Popular Posts:
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Get the Definition of a View Out of the SQL Server in SQL Server? If you want get the definit...