Case sensitive mysql query.

by Guna 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'

Tagged in:

661
like
0
dislike
0
mail
flag

You must LOGIN to add comments