# TableSelect class

(PECL mysql-xdevapi >= 8.0.11)

## Introduction

A statement for record retrieval operations on a Table.

## Class synopsis

class mysql_xdevapi\TableSelect implements mysql_xdevapi\Executable {
/* Methods */
public bind(array `$placeholder_values`): mysql_xdevapi\TableSelect
public execute(): mysql_xdevapi\RowResult
public groupBy(mixed `$sort_expr`): mysql_xdevapi\TableSelect
public having(string `$sort_expr`): mysql_xdevapi\TableSelect
public limit(int `$rows`): mysql_xdevapi\TableSelect
public lockExclusive(int `$lock_waiting_option` = ?): mysql_xdevapi\TableSelect
public lockShared(int `$lock_waiting_option` = ?): mysql_xdevapi\TableSelect
public offset(int `$position`): mysql_xdevapi\TableSelect
public orderby(mixed `$sort_expr`, mixed `...$sort_exprs`): mysql_xdevapi\TableSelect
public where(string `$where_expr`): mysql_xdevapi\TableSelect
}

## Table of Contents

- TableSelect::bind — Bind select query parameters
- TableSelect::__construct — TableSelect constructor
- TableSelect::execute — Execute select statement
- TableSelect::groupBy — Set select grouping criteria
- TableSelect::having — Set select having condition
- TableSelect::limit — Limit selected rows
- TableSelect::lockExclusive — Execute EXCLUSIVE LOCK
- TableSelect::lockShared — Execute SHARED LOCK
- TableSelect::offset — Set limit offset
- TableSelect::orderby — Set select sort criteria
- TableSelect::where — Set select search condition

`↑` and `↓` to navigate • `Enter` to select • `Esc` to close • `/` to open