Case sensitive mysql query.
by Guna[ Edit ] 2014-05-07 19:08:30
MySql queries are case insensitive by default, so if you search for rows which contains "Apache", it will also lists you rows that contains "apache".
To make this query case sensitive we can use "binary
" keyword infront of the column. example,
select * from table where binary column='Apache'