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)
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'". |
