MySQL Case-Sensitive Query

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...

PLAIN TEXT
SQL:
  1. 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:

PLAIN TEXT
SQL:
  1. SELECT *  FROM `table` WHERE BINARY `column` = 'value'

These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
  • Netvouz
  • DZone
  • Reddit
  • Furl
  • NewsVine
  • Simpy
  • Slashdot
  • Spurl
  • StumbleUpon
  • YahooMyWeb
  • TailRank
Home | MySQL | MySQL Case-Sensitive Query

You’re currently reading “ MySQL Case-Sensitive Query ,” an entry on BRADINO

Published:
3.24.07 / 9am
Category:
MySQL