Quick Search:
 
 mySQL: CaSe sEnsiTvE query Jump to:  
Category: >> mySQL >> CaSe sEnsiTvE query  

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

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


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org