Using WHERE in MySQL with Node.js lets you filter records based on conditions — perfect for finding specific users, products, or any other data.

Let’s break it down with real examples 👇

✅ Step 1: Install MySQL Package

bash
npm install mysql      SELECT * FROM users WHERE age > 25;

Using mysql (Callback style)

js
const mysql = require('mysql');const connection = mysql.createConnection({  host: 'localhost',  user: 'root',  password: '',  database: 'myDatabase'});connection.connect();const sql = 'SELECT * FROM users WHERE age > ?';const values = [25];connection.query(sql, values, (err, results) => {  if (err) throw err;  console.table(results);  connection.end();});

Using mysql2 (Async/Await)

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

🔁 More WHERE Examples

🛡️ Always Use Placeholders

js
'SELECT * FROM users WHERE name = ? AND age > ?'

Using placeholders (?) helps prevent SQL injection 🔒