MySQL tutorial: IS_IPV4 [EN]

top of page

MySQL:

IS_IPV4

Syntax:
IS_IPV4(expr)

Returns 1 if the argument is a valid IPv4 address specified as a
string, 0 otherwise.

URL: https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html

Example

mysql> SELECT IS_IPV4('10.0.5.9'), IS_IPV4('10.0.5.256');
-> 1, 0

bottom of page