Tag Archives: case-sensitive

• 

  Case Sensitive Query in MySQL

  Posted on August 3, 2009 by Way in Blog, Other Technologies, SQL

  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 = [...]

  1 Comment. Continue Reading...