# TableSelect class

(PECL mysql-xdevapi >= 8.0.11)

## Introduction

A statement for record retrieval operations on a Table.

## Class synopsis

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