MySQL: is a SELECT statement case sensitive?

by

They are case insensitive, unless you do a binary comparison.

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. How can I select data from different tables?
  3. Select all columns except one in MySQL?
  4. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  5. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  6. MySQL Query – Records between Today and Last 30 Days
  7. Ordering by specific field value first
  8. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  9. INSERT INTO…SELECT for all MySQL columns
  10. Select mysql query between date?
  11. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  12. mysql select from n last rows
  13. Checking multiple columns for one value
  14. MySQL difference between two rows of a SELECT Statement
  15. Sort by order of values in a select statement “in” clause in mysql
  16. MySQL – How to search for exact word match using LIKE?
  17. MySQL – How to select data by string length
  18. Return a default value if single row is not found
  19. MySQL – Select the last inserted row easiest way
  20. Sum results of a few queries and then find top 5 in SQL
  21. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  22. Syntax error when using except in a query
  23. SELECT query return 1 row from each group
  24. SQL query to check if a name begins and ends with a vowel
  25. Using index, using temporary, using filesort – how to fix this?
  26. MySQL : retrieve a large select by chunks
  27. MySQL – insert data from another table merged with constants
  28. MySQL Error: #1142 – SELECT command denied to user
  29. How to SELECT by MAX(date)?
  30. MySQL matching unicode characters with ascii version

Leave a Comment