Топ-100
 

IS_IPV4

База данных: MySQL
Текст

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

Пример

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