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(); |