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.
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'".
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.