CODEWITHSUNDEEP
mysql
Pratik Patel
Pratik Patel

Reputation: 239

case sensitive select query in mysql

Here Problem is make sql query is not check case sensitive latters Here SQL Version;

 VERSION(): 8.0.15

Sql Query for login user:

SELECT COUNT(*) as cnt FROM accounts WHERE (number = 'AdMin' OR email = 'AdMin') AND password = '******' AND type IN (1) AND deleted = 0

Database store name='admin'

here how to set case sensitive sql query for mysql 8.0 and stop login when username ='AdMin'

Upvotes: 1

Views: 58

Answers (1)

Nick
Nick

Reputation: 147146

You need to use the BINARY operator to make your search case sensitive:

SELECT COUNT(*) as cnt 
FROM accounts 
WHERE (number = BINARY 'AdMin' OR email = BINARY 'AdMin') AND password = '******' AND type IN (1) AND deleted = 0

Demo on dbfiddle

Upvotes: 2

Related Questions