The default return result of MySQL query is case insensitive, e.g.
| header |
|---|
| label |
SELECT header FROM table WHERE header = "LABEL"
Result:
label
If you want the result of the query to be case sensitive. You have to add keyword “BINARY” in front of the field name.
SELECT header FROM table WHERE BINARY header = "LABEL"
Result:
null
References:
0 Responses
Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.