Mysql select query case-sensitive methods (1/3)

1. You can set collation for a table or row to binary or case sensitive. In the mysql tutorial, the naming conventions for column collate are as follows:

* _ Bin: binary case sensitive collation, that is, case sensitive.
* _ Cs: case sensitive collation, case sensitive
* _ Ci: case insensitive collation, case insensitive

 

###########
# Start binary collation example
###########
Mysql> create table case_bin_test (word varchar (10) character set latin1 collate latin1_bin;
Query OK, 0 rows affected (0.02 sec)

Mysql> insert into case_bin_test values ('frank'), ('Google '), ('froog'), ('flickr'), ('flickr ');
Query OK, 5 rows affected (0.00 sec)
Records: 5 duplicates: 0 warnings: 0

Mysql> select * from case_bin_test where word like 'f % ';
+ --------- +
| Word |
+ --------- +
| Froogle |
| Flickr |
+ --------- +
2 rows in set (0.00 sec)

Mysql> select * from case_bin_test where word like 'f % ';
+ --------- +
| Word |
+ --------- +
| Frank |
| Flickr |
+ --------- +
4 rows in set (0.00 sec)

###########
# End
########## 1 2 3