W3cubDocs

/Drupal 8

interface SelectInterface

Interface definition for a Select Query object.

Hierarchy

Related topics

Database abstraction layer
Allow the use of different database servers using the same code base.

File

core/lib/Drupal/Core/Database/Query/SelectInterface.php, line 12

Namespace

Drupal\Core\Database\Query

Members

Name Modifiers Type Description
AlterableInterface::addMetaData public function Adds additional metadata to the query.
AlterableInterface::addTag public function Adds a tag to a query.
AlterableInterface::getMetaData public function Retrieves a given piece of metadata.
AlterableInterface::hasAllTags public function Determines if a given query has all specified tags.
AlterableInterface::hasAnyTag public function Determines if a given query has any specified tag.
AlterableInterface::hasTag public function Determines if a given query has a given tag.
ConditionInterface::andConditionGroup public function Creates a new group of conditions ANDed together.
ConditionInterface::arguments public function Gets a complete list of all values to insert into the prepared statement.
ConditionInterface::compile public function Compiles the saved conditions for later retrieval.
ConditionInterface::compiled public function Check whether a condition has been previously compiled.
ConditionInterface::condition public function Helper function: builds the most common conditional clauses.
ConditionInterface::conditionGroupFactory public function Creates an object holding a group of conditions.
ConditionInterface::conditions public function Gets a complete list of all conditions in this conditional clause.
ConditionInterface::exists public function Sets a condition that the specified subquery returns values.
ConditionInterface::isNotNull public function Sets a condition that the specified field be NOT NULL.
ConditionInterface::isNull public function Sets a condition that the specified field be NULL.
ConditionInterface::notExists public function Sets a condition that the specified subquery returns no values.
ConditionInterface::orConditionGroup public function Creates a new group of conditions ORed together.
ConditionInterface::where public function Adds an arbitrary WHERE clause to the query.
ExtendableInterface::extend public function Enhance this object by wrapping it in an extender object.
PlaceholderInterface::nextPlaceholder public function Returns the next placeholder ID for the query.
PlaceholderInterface::uniqueIdentifier public function Returns a unique identifier for this object.
SelectInterface::addExpression public function Adds an expression to the list of "fields" to be SELECTed.
SelectInterface::addField public function Adds a field to the list to be SELECTed.
SelectInterface::addJoin public function Join against another table in the database.
SelectInterface::countQuery public function Get the equivalent COUNT query of this query as a new query object.
SelectInterface::distinct public function Sets this query to be DISTINCT.
SelectInterface::escapeField public function Escapes a field name string.
SelectInterface::escapeLike public function Escapes characters that work as wildcard characters in a LIKE pattern.
SelectInterface::execute public function Runs the query against the database.
SelectInterface::fields public function Add multiple fields from the same table to be SELECTed.
SelectInterface::forUpdate public function Add FOR UPDATE to the query.
SelectInterface::getArguments public function Compiles and returns an associative array of the arguments for this prepared statement.
SelectInterface::getExpressions public function Returns a reference to the expressions array for this query.
SelectInterface::getFields public function Returns a reference to the fields array for this query.
SelectInterface::getGroupBy public function Returns a reference to the group-by array for this query.
SelectInterface::getOrderBy public function Returns a reference to the order by array for this query.
SelectInterface::getTables public function Returns a reference to the tables array for this query.
SelectInterface::getUnion public function Returns a reference to the union queries for this query. This include queries for UNION, UNION ALL, and UNION DISTINCT.
SelectInterface::groupBy public function Groups the result set by the specified field.
SelectInterface::having public function Adds an arbitrary HAVING clause to the query.
SelectInterface::havingArguments public function Gets a list of all values to insert into the HAVING clause.
SelectInterface::havingCompile public function Compiles the HAVING clause for later retrieval.
SelectInterface::havingCondition public function Helper function to build most common HAVING conditional clauses.
SelectInterface::havingConditions public function Gets a list of all conditions in the HAVING clause.
SelectInterface::havingExists public function Sets a HAVING condition that the specified subquery returns values.
SelectInterface::havingIsNotNull public function Sets a condition in the HAVING clause that the specified field be NOT NULL.
SelectInterface::havingIsNull public function Sets a condition in the HAVING clause that the specified field be NULL.
SelectInterface::havingNotExists public function Sets a HAVING condition that the specified subquery returns no values.
SelectInterface::innerJoin public function Inner Join against another table in the database.
SelectInterface::isPrepared public function Indicates if preExecute() has already been called on that object.
SelectInterface::join public function Default Join against another table in the database.
SelectInterface::leftJoin public function Left Outer Join against another table in the database.
SelectInterface::orderBy public function Orders the result set by a given field.
SelectInterface::orderRandom public function Orders the result set by a random value.
SelectInterface::preExecute public function Generic preparation and validation for a SELECT query.
SelectInterface::range public function Restricts a query to a given range in the result set.
SelectInterface::rightJoin public function Right Outer Join against another table in the database.
SelectInterface::union public function Add another Select query to UNION to this one.
SelectInterface::__clone public function Clone magic method.
SelectInterface::__toString public function Returns a string representation of how the query will be executed in SQL.

© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/core!lib!Drupal!Core!Database!Query!SelectInterface.php/interface/SelectInterface/8.1.x