Using ORDER BY in MySQL with Node.js lets you sort your query results by one or more columns — ascending (ASC) or descending (DESC).

Let’s see how to use it in your Node.js app step-by-step 👇

✅ Step 1: Install MySQL Package

bash
npm install mysql      const mysql = require('mysql');const connection = mysql.createConnection({  host: 'localhost',  user: 'root',  password: '',  database: 'myDatabase'});connection.connect();const sql = 'SELECT * FROM users ORDER BY age ASC';connection.query(sql, (err, results) => {  const sql = 'SELECT * FROM users ORDER BY name DESC';connection.query(sql, (err, results) => {  if (err) throw err;  console.log('Users ordered by name (descending):');  console.table(results);});

🔹 Using mysql2 with async/await

js
const mysql = require('mysql2/promise');async function getSortedUsers() {  const connection = await mysql.createConnection({    host: 'localhost',    user: 'root',    password: '',    database: 'myDatabase'  });  const [rows] = await connection.execute('SELECT * FROM users ORDER BY age DESC');  console.table(rows);  await connection.end();}getSortedUsers();

🧠 ORDER BY Tips