there might be other ways but, i find this one the easiest<pre class="ql-syntax" spellcheck="false">where user_type COLLATE utf8mb4_0900_as_cs = 'p'
</pre>the above query will bring up all the users with user_type 'p' in lower case.

How to make a where query in MySQL with Case Sensitive query string

below is the list of commands for sequelize cli<h2>Create Model with Migration</h2><pre class="ql-syntax" spellcheck="false">npx sequelize-cli model:generate --name User --attributes name:string,first_name:string
</pre><h2>Create Migration</h2><pre class="ql-syntax" spellcheck="false">npx sequelize-cli migration:create --name modify_rates_add_weight
</pre><h2>Run Migration</h2><pre class="ql-syntax" spellcheck="false">npx sequelize-cli db:migrate --env=development
</pre><h2>Adding Foreign Key to Migrations</h2><pre class="ql-syntax" spellcheck="false">type: Sequelize.INTEGER,
references: {
 model: "vendors", // tables name not model name
 key: 'id'
}
</pre><h2>Create Seed</h2><pre class="ql-syntax" spellcheck="false">npx sequelize-cli seed:generate --name shippers
</pre><h2>Timestamp In Seed</h2><pre class="ql-syntax" spellcheck="false">created_at: new Date(),
updated_at: new Date()
</pre><h2>Run Seeder</h2><pre class="ql-syntax" spellcheck="false">npx sequelize-cli db:seed:all
</pre><h2>Run Single Seeder </h2><pre class="ql-syntax" spellcheck="false">npx sequelize-cli db:seed --seed 20220622131903-file_name.js
</pre><h2>List all available CLI commands</h2><pre class="ql-syntax" spellcheck="false">npx sequelize-cli --list
</pre><h2>References</h2><ul><li>npx sequelize-cli db:migrate | Run pending migrations</li><li>npx sequelize-cli db:migrate:schema:timestamps:add | Update migration table to have timestamps</li><li>npx sequelize-cli db:migrate:status | List the status of all migrations</li><li>npx sequelize-cli db:migrate:undo | Reverts a migration</li><li>npx sequelize-cli db:migrate:undo:all | Revert all migrations ran</li><li>npx sequelize-cli db:seed | Run specified seeder</li><li>npx sequelize-cli db:seed:undo | Deletes data from the database</li><li>npx sequelize-cli db:seed:all | Run every seeder</li><li>npx sequelize-cli db:seed:undo:all | Deletes data from the database</li><li>npx sequelize-cli db:create | Create database specified by configuration</li><li>npx sequelize-cli db:drop | Drop database specified by configuration</li><li>npx sequelize-cli init | Initializes project</li><li>npx sequelize-cli init:config | Initializes configuration</li><li>npx sequelize-cli init:migrations | Initializes migrations</li><li>npx sequelize-cli init:models | Initializes models</li><li>npx sequelize-cli init:seeders | Initializes seeders</li><li>npx sequelize-cli migration:generate | Generates a new migration file</li><li>npx sequelize-cli migration:create | Generates a new migration file</li><li>npx sequelize-cli model:generate | Generates a model and its migration</li><li>npx sequelize-cli model:create | Generates a model and its migration</li><li>npx sequelize-cli seed:generate | Generates a new seed file</li><li>npx sequelize-cli seed:create | Generates a new seed file</li></ul>

Sequelize CLI Commands

In the very initial days of my work in Node JS if faced this issue. Though Sequelize provide a great ORM for MySQL but the association within the models is a bit tricky. you can find more about associations <a href="https://sequelize.org/master/manual/assocs.html" rel="noopener noreferrer">here</a>Before getting any further, if you want to get a setup for fully function code setup <a href="https://github.com/msamgan/expressjs-api-boilerplate" rel="noopener noreferrer">here it is</a><h2>Preface</h2>For the sake of understanding, lets consider two Models please inside the model directory, models/author.js and models/post.js. Models will look like as follows respectively.<h2>Author Model (models/author.js)</h2><pre class="ql-syntax" spellcheck="false" data-cacher="true" data-cacher-block-id="2221063348">'use strict';
const {
 Model
} = require('sequelize');
module.exports = (sequelize, DataTypes) =&gt; {
 class Author extends Model {
 /**
 * Helper method for defining associations.
 * This method is not a part of Sequelize lifecycle.
 * The `models/index` file will call this method automatically.
 */
 static associate(models) {
 // define association here
 }
 };

 Author.init({
 slug: DataTypes.STRING,
 name: DataTypes.STRING,
 }, {
 sequelize,
 modelName: 'Author',
 tableName: 'authors',
 });


 return Author;
};
</pre><h2>Post Model (models/post.js)</h2><pre class="ql-syntax" spellcheck="false" data-cacher="true" data-cacher-block-id="3112237828">'use strict';
const {
 Model,
} = require('sequelize');

module.exports = (sequelize, DataTypes) =&gt; {
 class Post extends Model {
 /**
 * Helper method for defining associations.
 * This method is not a part of Sequelize lifecycle.
 * The `models/index` file will call this method automatically.
 */
 static associate(models) {
 this.belongsTo(models.Author, {as: 'Author'});
 }
 }


 Post.init({
 slug: DataTypes.STRING,
 title: DataTypes.STRING,
 excerpt: DataTypes.STRING
 }, {
 sequelize,
 modelName: 'Post',
 tableName: 'posts',
 });

 return Post;
};
</pre>As shown in the post model, a belongs too association is made between Post and author. But as the comment suggest, associate method is not a part of Sequelize lifecycle. we have to call it manually.To achieve that, we need to create models/index.js with the following content.<h2>models/index.js</h2><pre class="ql-syntax" spellcheck="false" data-cacher="true" data-cacher-block-id="3338581372">'use strict';

const fs = require('fs');
const path = require('path');
const Sequelize = require('sequelize');
const basename = path.basename(__filename);
const env = process.env.NODE_ENV || 'development';
const config = require(__dirname + '/../config/database.json')[env];
const db = {};

let sequelize;
if (config.use_env_variable) {
 sequelize = new Sequelize(process.env[config.use_env_variable], config);
} else {
 sequelize = new Sequelize(config.database, config.username, config.password, config);
}

fs
 .readdirSync(__dirname)
 .filter(file =&gt; {
 return (file.indexOf('.') !== 0) &amp;&amp; (file !== basename) &amp;&amp; (file.slice(-3) === '.js');
 })
 .forEach(file =&gt; {
 const model = require(path.join(__dirname, file))(sequelize, Sequelize.DataTypes);
 db[model.name] = model;
 });

Object.keys(db).forEach(modelName =&gt; {
 if (db[modelName].associate) {
 db[modelName].associate(db);
 }
});

db.sequelize = sequelize;
db.Sequelize = Sequelize;

module.exports = db;

</pre>Ones you are done with this you can access all you models vie models/index.js<h2>Accessing Models</h2><pre class="ql-syntax" spellcheck="false" data-cacher="true" data-cacher-block-id="4182884854">const {Post, Author} = require('../../models');
</pre>You can find more about hoe to use association in accessing data <a href="https://sequelize.org/master/manual/creating-with-associations.html" rel="noopener noreferrer">here</a>GitHub Repo for the <a href="https://github.com/msamgan/expressjs-api-boilerplate" rel="noopener noreferrer">above code</a><div class="inline_html" contenteditable="false"><iframe width="100%" height="500" src="https://www.youtube.com/embed/ctdMkbwHBU0" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen=""></iframe></div>

In the very initial days of my work in Node JS if faced this issue. Though Sequelize provide a great ORM for MySQL but the association within the models is a bit tricky.