MySQL Expert

Query MySQL with easy field selection - only get the data you need

Actions6

Table → Select

AI-generated

Summary

Select rows from a specified MySQL table, optionally filtering, sorting, and limiting the results with precise field selection.

Inputs

  • table (required) — The target table to select data from, chosen from the database or set via expression.
  • fieldsToInclude — Specific columns to retrieve; leave empty to select all columns.
  • returnAll — Boolean to indicate whether to return all matching rows or limit the number of returned rows.
  • limit — Max number of rows to return if 'Return All' is false.
  • filters — Conditions to filter the rows by, with support for multiple constraints combined by AND or OR.
  • combineFilters — Logical operator ('AND' or 'OR') to combine multiple filter conditions.
  • sort — Rules to sort the results by specified columns and directions (ascending or descending).
  • options.distinct — Remove duplicate rows by selecting distinct results.
  • options.queryBatching — How to execute multiple queries (single, independently, or in a transaction).

Output shape

a list of JSON objects where each object represents a row from the selected table matching the query criteria.

If multiple input items are processed, results are combined. Filters support various SQL operators. Limits apply only when 'Return All' is false. Distinct option removes duplicates.

Links

Discussion