Home / Questions / 44772
Accepted
Jorius
Asked: 2020-01-19 12:56:40 +0800 CST 2020-01-19 12:56:40 +0800 CST

Differentiate between upper and lower case within a WHERE in MySQL

  • 772

I have the following query:

SELECT * FROM tbl_descriptores WHERE nombre = 'dulce';

Which brings me the following results:

_________________________________________________________________
|idDescriptor |idDescriptorPadre |nombre |name |colorhex | tipo |
_________________________________________________________________
|21           |270               |Dulce  |Sweet|DDA0DD   |2     |
_________________________________________________________________
|127          |0                 |DULCE  |SWEET|FCF9CC   |1     |
_________________________________________________________________

I would like to know how I can do the queryand that it differentiates between uppercase and lowercase , that is: if my criteria is 'sweet' , it should not bring me anything since there is no record in the table where the name column is called 'sweet', if my criteria is 'Sweet' , it will bring me the record with idDescriptor 21and if my criteria is 'SWEET' , it will bring me the record with the idDescriptor 127. How can I do it?

mysql

1 Answers

  1. Best Answer

    You need to use the command BINARY:

    SELECT * 
FROM tbl_descriptores 
WHERE nombre = BINARY 'dulce';
    • 14