DB::DBAL

The World's Most Powerful Light-Weight DBAL

OrderBy

orderBy( string $order_by_statement )

The orderBy() method allows you to determine how the results are ordered.

1
2
3
4
5
// ASC by default
DB::MySQL()->table('myTable')->select()->orderBy('column');
// Order DESC
DB::MySQL()->table('myTable')->select()->orderBy('column DESC');

You may use multiple orderBy() methods on one query chain, but they will all be used in the query. To remove the ORDER BY clause, use the removeOrderBy() method.

1
2
3
// Query Ordered By column, column2
$stmt = DB::MySQL()->table('myTable')->select()->orderBy('column');
$stmt->orderBy('column2');

removeOrderBy( void )

1
2
3
4
5
6
// Query Ordered By column, column2
$stmt = DB::MySQL()->table('myTable')->select()->orderBy('column');
$stmt->orderBy('column2');
// Query is no longer Ordered:
$stmt->removeOrderBy();