function SelectInterface::orderRandom
Same name in other branches
- 9 core/lib/Drupal/Core/Database/Query/SelectInterface.php \Drupal\Core\Database\Query\SelectInterface::orderRandom()
- 8.9.x core/lib/Drupal/Core/Database/Query/SelectInterface.php \Drupal\Core\Database\Query\SelectInterface::orderRandom()
- 11.x core/lib/Drupal/Core/Database/Query/SelectInterface.php \Drupal\Core\Database\Query\SelectInterface::orderRandom()
Orders the result set by a random value.
This may be stacked with other orderBy() calls. If so, the query will order by each specified field, including this one, in the order called. Although this method may be called multiple times on the same query, doing so is not particularly useful.
Note: The method used by most drivers may not scale to very large result sets. If you need to work with extremely large data sets, you may create your own database driver by subclassing off of an existing driver and implementing your own randomization mechanism. See
http://jan.kneschke.de/projects/mysql/order-by-rand/
for an example of such an alternate sorting mechanism.
Return value
$this The called object
2 methods override SelectInterface::orderRandom()
- Select::orderRandom in core/
lib/ Drupal/ Core/ Database/ Query/ Select.php - Orders the result set by a random value.
- SelectExtender::orderRandom in core/
lib/ Drupal/ Core/ Database/ Query/ SelectExtender.php - Orders the result set by a random value.
File
-
core/
lib/ Drupal/ Core/ Database/ Query/ SelectInterface.php, line 415
Class
- SelectInterface
- Interface definition for a Select Query object.
Namespace
Drupal\Core\Database\QueryCode
public function orderRandom();
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.