How to detect an IPv4 Address using the IS_IPV6() function?

IS_IPV6(ip) is a MySQL built-in function that returns 1 if the given value is a valid IPv6 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_IPV6() function:

IS_IPV6(ip): boolean
  Returns 1 if and only if the argument is a valid IPv6 address.

Arguments, return value and availability:
  ip: Required. The IPv6 address to be examined.
  boolean: Return value. 
    1 if and only if the argument is a valid IPv6 address.
  Available since MySQL 4.0.

Related MySQL functions:

• IS_IPV4() - Detecting IPv4 Address
• IS_IPV4_COMPAT() - IPv4-Compatible IPv6 Address
• IS_IPV4_MAPPED() - IPv4-Mapped IPv6 Address
• IS_IPV6() - Detecting IPv6 Address

⇒ IS_USED_LOCK() - Checking Lock Owner

⇐ IS_IPV4_MAPPED() - IPv4-Mapped IPv6 Address

⇑ MySQL Functions for Miscellaneous Purposes

⇑⇑ MySQL Function References