# mariadb-find-rows

`mariadb-find-rows` reads files containing SQL statements and extracts statements that match a given regular expression or that contain [USE db\_name](/docs/server/reference/sql-statements/administrative-sql-statements/use-database.md) or [SET](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set.md) statements.

Previously, the client was called `mysql_find_rows`. It can still be accessed under this name, via a symlink in Linux, or an alternate binary in Windows.

The utility was written for use with update log files (as used prior to MySQL 5.0), and as such expects statements to be terminated with semicolon (`;`) characters. It may be useful with other files that contain SQL statements, as long as statements are terminated with semicolons.

## Usage

```
mariadb-find-rows [options] [file_name ...]
```

Each file\_name argument should be the name of file containing SQL statements. If no file names are given, the tool reads from `stdin` (standard input).

## Options

`mariadb-find-rows` supports the following options:

| Option                | Description                                                                                                                                  |
| --------------------- | -------------------------------------------------------------------------------------------------------------------------------------------- |
| --help, --Information | Display help and exit.                                                                                                                       |
| --regexp=*pattern*    | Display queries that match *pattern*.                                                                                                        |
| --rows=N              | Quit after displaying *N* queries.                                                                                                           |
| --skip-use-db         | Do not include [USE db\_name](/docs/server/reference/sql-statements/administrative-sql-statements/use-database.md) statements in the output. |
| --start\_row=*N*      | Start output from this row (first row is `1`).                                                                                               |

## Examples

```
mariadb-find-rows --regexp=problem_table --rows=20 < update.log
mariadb-find-rows --regexp=problem_table  update-log.1 update-log.2
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/clients-and-utilities/administrative-tools/mariadb-find-rows.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.