# **EMPTY()**

## **Function Description**

Determines whether the entered string is empty. If at least one byte is included, it is not empty, even if it is a space or NULL.

## **Function Syntax**

```text
> EMPTY(str)
```

## **Parameter definition**

| Parameters | Description |
| ---- | ---- |
| str | Required parameters, CHAR and VARCHAR types are available. |

## **Return value**

Empty string returns 1, non-empty string returns 0.

## **Example**

```text
> drop table if exists t1;
> create table t1(a varchar(255),b varchar(255));
> insert into t1 values('', 'abcd');
> insert into t1 values('1111', '');
> select empty(a),empty(b) from t1;
+-------------------------+
| empty(a) | empty(b) |
+-------------------------+
| 1 | 0 |
| 0 | 1 |
+-------------------------+
```