mysql> select * from user; +--------+------+ | id | name | +--------+------+ | 100 | aaa | | 1001 | bbb | | 100001 | ccc | +--------+------+ 3 rows in set (0.00 sec)mysql> select * from user where id='100'; +------+------+ | id | name | +------+------+ | 100 | aaa | +------+------+ 1 row in set (0.03 sec)
+--------+------+
| id | name |
+--------+------+
| 100 | aaa |
| 1001 | bbb |
| 100001 | ccc |
+--------+------+
3 rows in set (0.00 sec)mysql> select * from user where id='100';
+------+------+
| id | name |
+------+------+
| 100 | aaa |
+------+------+
1 row in set (0.03 sec)