There might be other ways but, I find this one the easiest
where user_type COLLATE utf8mb4_0900_as_cs = 'p'
The above query will bring up all the users with user_type 'p' in lowercase.
How To Make A Where Query In Mysql With Case Sensitive Query String
msamgan
August 31, 2022
Related posts
How to run MySql in Docker with Data Persistence
November 13, 2024
Run MySQL in Docker with data retention by using persistent storage volumes, ensuring data persists across container restarts and recreations.
How to Detect and Fix n+1 Queries in Laravel
August 2, 2024
Learn to detect and fix n+1 queries in Laravel to optimize your application's performance. Discover practical tips and tools to identify and resolve this common issue, ensuring efficient database interactions and faster load times.
How to Contribute to Laravel: A Step-by-Step Guide
June 27, 2024
You can learn how to contribute to Laravel with our step-by-step guide. From setting up your environment to submitting pull requests, we cover everything you need to know to make meaningful contributions to the Laravel framework.
Command to import DB through the command line in MySQL
June 14, 2024
Command to import DB through the command line in MySQL
How to create ToolTip in Tailwind css
June 6, 2024
Below is how you create a tooltip in tailwind CSS without any external library.
How to Cache in NodeJs APIs
March 1, 2024
Speed is what all web/mobile apps need. And with growing database size, the speed is the first thing that takes a hit. Comes cache to rescue.
How to use .env keys in sequelize cli configuration
September 13, 2023
To use environment variables (stored in a .env file) in your Sequelize CLI configuration, you'll need to use a package like dotenv to load the variables and then access them in your configuration file.
How to run MySql in Docker, a beginner's guide
September 8, 2023
Let me directly get to the point, Installing MySQL on a local machine can be tricky sometimes. In this article, you will know how to get rid of that issue.
How to get JetBrains IDEs for free
August 24, 2023
JetBrains offers a range of powerful integrated development environments (IDEs) like IntelliJ IDEA, PyCharm, PhpStorm, and more. While JetBrains does provide a free and open-source version for some of their IDEs
How to solve "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" on Mac
August 11, 2023
Neither by cli nor by UI tools. After doing some research I found out that this is caused because of some corrupted files on the installed package.
Support My Work
If you find my content helpful and want to see more quality articles, tools, and resources, consider supporting my work through GitHub Sponsors. Your support helps me dedicate more time to creating free, open-source content.
Become a sponsor
