Illuminate\Database\Query\Builder::orderByRaw PHP Method

orderByRaw() public method

Add a raw "order by" clause to the query.
public orderByRaw ( string $sql, array $bindings = [] )
$sql string
$bindings array
    public function orderByRaw($sql, $bindings = [])
    {
        $property = $this->unions ? 'unionOrders' : 'orders';
        $type = 'raw';
        $this->{$property}[] = compact('type', 'sql');
        $this->addBinding($bindings, 'order');
        return $this;
    }

Usage Example

 /**
  * Scope to order by random.
  *
  * @param  \Illuminate\Database\Query\Builder $query
  * @return \Illuminate\Database\Query\Builder
  */
 public function scopeOrderByRandom($query)
 {
     static $randomFunctions = ['mysql' => 'RAND()', 'pgsql' => 'RANDOM()', 'sqlite' => 'RANDOM()', 'sqlsrv' => 'NEWID()'];
     $driver = $this->getConnection()->getDriverName();
     return $query->orderByRaw($randomFunctions[$driver]);
 }
All Usage Examples Of Illuminate\Database\Query\Builder::orderByRaw