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
- How to Detect and Fix n+1 Queries in Laravel
- How to Contribute to Laravel: A Step-by-Step Guide
- Command to import DB through the command line in MySQL
- How to create ToolTip in Tailwind css
- How to Cache in NodeJs APIs
- How to use .env keys in sequelize cli configuration
- How to run MySql in Docker, a beginner's guide
- How to get JetBrains IDEs for free
- How to solve "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" on Mac
