MySQL Case-Sensitive Query

Like this blog? Consider exploring one of our sponsored banner ads...

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:

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

About this entry

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

Published:: 3.24.07 / 9am

Category:: MySQL

Tags:

3 Comments

Jump to comment form | comments rss [?] | trackback uri [?]

Have your say

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="" highlight="">

About

I was born and raised in Stockton, California (about 45 miles south of Sacramento). In 1999 I moved to San Diego to attend college. During college I started doing freelance web development, gaining invaluable experience.

Many years later I am now a PHP/MySQL Developer working full-time at a leading Online Advertising Agency in Downtown San Diego. Online Advertising is a fast-paced, exciting industry, that I thoroughly enjoy being a part of.

BRADINO

MySQL Case-Sensitive Query

About this entry

3 Comments

Have your say

About

Recently

Categories