Prepares and returns a SELECT query object.

Parameters

string|\Drupal\Core\Database\Query\SelectInterface $table: The base table name or subquery for this query, used in the FROM clause. If a string, the table specified will also be used as the "base" table for query_alter hook implementations.

string $alias: (optional) The alias of the base table of this query.

$options: An array of options on the query.

Return value

\Drupal\Core\Database\Query\SelectInterface An appropriate SelectQuery object for this database connection. Note that it may be a driver-specific subclass of SelectQuery, depending on the driver.

See also

\Drupal\Core\Database\Query\Select

File

core/lib/Drupal/Core/Database/Connection.php, line 1220

Class

Connection

Base Database API class.

Namespace

Drupal\Core\Database

Code

public function select($table, $alias = NULL, array $options = []) {
  if (!is_null($alias) && !is_string($alias)) {
    @trigger_error('Passing a non-string \'alias\' argument to ' . __METHOD__ . '() is deprecated in drupal:9.3.0 and will be required in drupal:10.0.0. Refactor your calling code. See https://www.drupal.org/project/drupal/issues/3216552', E_USER_DEPRECATED);
  }
  $class = $this->getDriverClass('Select');
  return new $class($this, $table, $alias, $options);
}

---