SQL サンプル - Node.js

データベース情報

CREATE DATABASE sample;

CREATE TABLE users (
  id INT AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  age INT NULL,
  PRIMARY KEY (id)
);

INSERT INTO users (name, age) VALUES ('Taro', 28);

あいまい検索

script.js

const mysql = require('mysql2/promise');

const pool = mysql.createPool({
    host: 'localhost',
    user: 'root',
    database: 'sample',
    password: 'password',
});

(async () => {
    try {
        const [results, fields] = await pool.query('SELECT * FROM users WHERE name LIKE ?', "Ta%");
        if(results.length){
            console.log(results);
        }
    } catch (err) {
        console.log(err);
    }
    pool.end();
})();

// 結果
[ { id: 1, name: 'Taro', age: 28 } ]