# mysql\_fetch\_field

## Syntax

```c
MYSQL_FIELD * mysql_fetch_field(MYSQL_RES * result);
```

* `result` - a result set identifier returned by [mysql\_store\_result()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_store_result) or [mysql\_use\_result()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_use_result).

## Description

Returns the definition of one column of a result set as a pointer to a MYSQL\_FIELD structure. Call this function repeatedly to retrieve information about all columns in the result set.

{% hint style="info" %}
The field order will be reset if you execute a new SELECT query.

In case only information for a specific field is required the field can be selected by using the [mysql\_field\_seek()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_field_seek) function or obtained by [mysql\_fetch\_field\_direct()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_fetch_field_direct) function.
{% endhint %}

## See also

* [mysql\_field\_seek()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_field_seek)
* [mysql\_field\_tell()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_field_tell)
* [mysql\_fetch\_field\_direct()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_fetch_field_direct)
* [mysql\_store\_result()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_store_result)
* [mysql\_use\_result()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_use_result)

{% @marketo/form formId="4316" %}