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 • Wed Aug 31 2022
