Shulou(Shulou.com)06/01 Report--

CREATE TABLE animals (

Id MEDIUMINT NOT NULL AUTO_INCREMENT

Name CHAR (30) NOT NULL

PRIMARY KEY (id)

);

Insert into animals values (null,'kitty'), (null,'KITTY'), (null,'hello')

# useless binary

Select id from animals where name like'% it%'

+-- +

| | id |

+-- +

| | 1 |

| | 2 |

+-- +

2 rows in set (0.00 sec)

# using binary

Select id from animals where name like binary'% it%'

+-- +

| | id |

+-- +

| | 1 |

+-- +

1 row in set (0.03 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.