When I filter numeric id with where condition inside with key all then result is like this which is correct https://prnt.sc/1ubkviy

But when we pass alpha numeric value inside where condition, still it is giving result then can you explain us in detail why this is happening https://prnt.sc/1ubkzbq

CodePudding user response：

Try using BINARY for exact match:

SELECT * FROM office_category WHERE BINARY id="2sssss"