MySQL case sensitive query [duplicate]

by

MySQL queries are not case-sensitive by default. Following is a simple query that is looking for 'value'. However it will return 'VALUE', 'value', 'VaLuE', etc…

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

The good news is that if you need to make a case-sensitive query, it is very easy to do using the BINARY operator, which forces a byte by byte comparison:

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

More Related Contents:

  1. How can I make SQL case sensitive string comparison on MySQL?
  2. Are table names in MySQL case sensitive?
  3. Are column and table name case sensitive in MySQL?
  4. Like Case Sensitive in MySQL
  5. SQL unique varchar case sensitivity question
  6. How to force case sensitive table names?
  7. How do you force mysql LIKE to be case sensitive? [duplicate]
  8. MySQL’s lower_case_table_names won’t change
  9. Using LIMIT within GROUP BY to get N results per group?
  10. How can I output MySQL query results in CSV format?
  11. Change limit for “Mysql Row size too large”
  12. Converting a date in MySQL from string field
  13. Quick easy way to migrate SQLite3 to MySQL? [closed]
  14. Using MySQL query to traverse rows to make a recursive tree
  15. Suppress warning messages using mysql from within Terminal, but password written in bash script
  16. How can I view live MySQL queries?
  17. Is it possible to execute a string in MySQL?
  18. Cannot connect to Database server (mysql workbench)
  19. Incorrect string value: ‘\xF0\x9F\x8E\xB6\xF0\x9F…’ MySQL
  20. MYSQL ORDER BY CASE Issue
  21. MySQL difference between two rows of a SELECT Statement
  22. connecting to mysql server on another PC in LAN
  23. storing money amounts in mysql
  24. Is incrementing a field in MySQL atomic?
  25. Delete from one table with join
  26. MySQL column type “TIMESTAMP” implicitly includes “NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”
  27. When to use a left outer join?
  28. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  29. Mysql server does not support 4-byte encoded utf8 characters
  30. Does MySQL support historical date (like 1200)?

Leave a Comment