Why Mysql doesn't handle case sensitive cases

Question

Why Mysql doesn't handle case sensitive cases

When I test below sql queries:

    1.  SELECT * FROM  table WHERE  username='username' AND password = 'password';

    2.  SELECT * FROM  table WHERE  username='Username' AND password = 'Password';

Both queries return the same result even if the username and password are case sensitive

+3

mysql cas

Amit Prajapati 08 june 17 at 4:34 am

source to share

2 answers

Optimized Bikash · Answer 1 · 2017-06-08T04:35:41+0000

Use this query

SELECT * FROM  table WHERE  username='Username' AND binary password = 'Password';

Harsh sharma · Answer 2 · 2017-06-08T04:37:03+0000

Syntax for Query Based on Case

SELECT *  FROM `table` WHERE BINARY `column` = 'value'

In your case, this would become:

SELECT * FROM  table WHERE BINARY username='Username' AND BINARY password = 'Password';

Why Mysql doesn't handle case sensitive cases

More articles: