MySQL 全文搜索与 Sequelize

使用 Sequelize 进行 MySQL 全文搜索的案例代码

javascript
const Sequelize = require('sequelize');
const Op = Sequelize.Op;
// 创建 Sequelize 实例
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql'
});
// 定义模型
const Post = sequelize.define('post', {
  title: {
    type: Sequelize.STRING,
    allowNull: false
  },
  content: {
    type: Sequelize.TEXT,
    allowNull: false
  }
});
// 执行全文搜索
const searchQuery = 'Sequelize 全文搜索';
Post.findAll({
  where: {
    [Op.or]: [
      {
        title: {
          [Op.like]: `%${searchQuery}%`
        }
      },
      {
        content: {
          [Op.like]: `%${searchQuery}%`
        }
      }
    ]
  }
}).then(posts => {
  console.log(posts);
}).catch(error => {
  console.error(error);
});