CoderZone.org

Category: >> mySQL >> CaSe sEnsiTvE query Bookmark and Share

<< lastnext >>

Snippet Name: CaSe sEnsiTvE query

Description: A query like "select * from customer where name = 'john'" also returns 'John' if it exists. Here's how to do a case-sensitive selection.

Comment: (none)

Author: CoderZone
Language: MYSQL
Highlight Mode: MYSQL
Last Modified: February 28th, 2009

-- A query like "select * from customer where name = 'john'" 
-- also returns 'John' if it exists.
 
-- Use "strcmp(name, 'john') = 0" in where-clause on MySQL 3.22.x.
 
 
-- Example where "$coupon" is compared with "coupon_code" case sensitively:
 
     $query = "SELECT * FROM coupons WHERE strcmp(coupon_code, '$coupon') = 0";
 
-mySQL 3.23.x also supports "binary name = 'john'". 
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 15