How to order a MySQL query by a specific column?

Question

i have a query here, and I am trying to sort the order they output by the column "rank", what would i add to my query exactly to do this? here is my code:

$query = $pdo->prepare('SELECT * 
                        FROM leaderboards 
                        WHERE game_id=2 AND mode_id=1 and map_id=15 
                        LIMIT 0, 100');

Possible duplicate of [MYSQL - ORDER BY & LIMIT](https://stackoverflow.com/questions/4708708/mysql-order-by-limit) — WMRamadan, Feb 15 '19 at 20:21

score 2 · Answer 1 · answered Jan 15 '14 at 14:20

If you want to order by a specific column, use the ORDER BY clause.

$query = $pdo->prepare('SELECT * 
                        FROM leaderboards 
                        WHERE game_id=2 AND mode_id=1 and map_id=15 
                        ORDER BY rank
                        LIMIT 0, 100');

score 1 · Answer 2 · answered Jan 15 '14 at 15:01

you even can use more that one field to sort, See below

$query = $pdo->prepare('SELECT * 
                        FROM leaderboards 
                        WHERE game_id=2 AND mode_id=1 and map_id=15 
                        ORDER BY rank, rank2
                        LIMIT 0, 100');

How to order a MySQL query by a specific column?

2 Answers2

Linked

Related