public function randomizeOrder(BaseStatement $statement) { $statement->order('RANDOM()'); }
/** * Randomizes result order. * @param BaseStatement $statement */ public function randomizeOrder(BaseStatement $statement) { switch ($this->driverName) { case 'mysql': case 'pgsql': $random = 'RAND()'; case 'sqlite': case 'sqlite2': $random = 'RANDOM()'; case 'odbc': $random = 'Rnd(id)'; case 'oci': $random = 'dbms_random.value'; case 'mssql': $random = 'NEWID()'; } $statement->order($random); }