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

Mohammed Samgan Khan

Application Security

Community Picks is a section on daily.dev where our community members share the most interesting and valuable content they've discovered online. From insightful articles to handy tools, every post is a gem curated by our dedicated coomunity. To contribute to Community Picks, you need to have at least 250 reputation points, ensuring that only active and trusted members can share their finds.

Community Picks

To perform a case-sensitive query in MySQL, you can use the COLLATE clause. For example, using `COLLATE utf8mb4_0900_as_cs` ensures that the query is case-sensitive for the specified string comparison.

<p>Try using <code>WHERE BINARY user_type = 'p'</code>. I’d say that’s a lot easier than figuring out a <code>COLLATE</code>. Also, this mostly applies to MySQL 5.7; I’m pretty sure they changed things in 8.</p>
