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
2023-12-17, 279🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...