How can I make SQL case sensitive string comparison on MySQL?

by

The good news is that if you need to make a case-sensitive query, it is very easy to do:

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

More Related Contents:

  1. MySQL query String contains
  2. SQL unique varchar case sensitivity question
  3. How do you force mysql LIKE to be case sensitive? [duplicate]
  4. Using LIMIT within GROUP BY to get N results per group?
  5. Can you use an alias in the WHERE clause in mysql?
  6. Select values that meet different conditions on different rows?
  7. MySQL error: key specification without a key length
  8. mysql update column with value from another table
  9. Select row with most recent date per user
  10. difference between primary key and unique key
  11. Illegal mix of collations MySQL Error
  12. SQL query: Delete all records from the table except latest N?
  13. SQL order string as number
  14. Rename a column in MySQL
  15. The total number of locks exceeds the lock table size
  16. update multiple rows using limit in mysql?
  17. Mysql 1050 Error “Table already exists” when in fact, it does not
  18. MySQL “IN” operator performance on (large?) number of values
  19. How to get the latest record in each group using GROUP BY? [duplicate]
  20. MySQL Select last 7 days
  21. How do I count columns of a table
  22. Difference between two table structure
  23. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  24. How to retrieve JSON data from MySQL?
  25. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  26. Why MySQL is giving error “Not allowed to return a result set from a function”?
  27. When to use a left outer join?
  28. MySQL 5.6 – DENSE_RANK like functionality without Order By
  29. Optimistic locking in MySQL
  30. Insert and set value with max()+1 problems

Leave a Comment