docs/sql-manual/sql-functions/ip-functions/to-ipv4.md

---
{
"title": "TO_IPV4",
"language": "en"
}
---

<!-- 
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements.  See the NOTICE file
distributed with this work for additional information
regarding copyright ownership.  The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License.  You may obtain a copy of the License at
  http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied.  See the License for the
specific language governing permissions and limitations
under the License.
-->

## TO_IPV4

TO_IPV4

### Description

#### Syntax

`IPV4 TO_IPV4(STRING ipv4_str)`

This function like ipv4_string_to_num that takes a string form of IPv4 address and returns value of IPv4 type,
which is binary equal to value returned by ipv4_string_to_num.
If the IPv4 address has an invalid format, throw an exception.

#### Notice

`Input cannot be NULL. If it is NULL, an exception will be thrown.`

### Example

```sql
mysql> select to_ipv4('255.255.255.255');
+----------------------------+
| to_ipv4('255.255.255.255') |
+----------------------------+
| 255.255.255.255            |
+----------------------------+
```

### Keywords

TO_IPV4, IP