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
How To Detect And Fix N+1 Queries In Laravel
August 2, 2024
How To Contribute To Laravel: A Step-By-Step Guide
June 27, 2024
Command To Import Db Through The Command Line In Mysql
June 14, 2024
How To Create Tooltip In Tailwind Css
June 6, 2024
How To Cache In Nodejs Apis
March 1, 2024
How To Use .Env Keys In Sequelize Cli Configuration
September 13, 2023
How To Run Mysql In Docker, A Beginner's Guide
September 8, 2023
How To Get Jetbrains Ides For Free
August 24, 2023
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
