mysql and查询_mysql中=0的and查询

mysql> select * from t_user;

+----+----------+----------+

| id | username | password |

+----+----------+----------+

| 1 | admin | admin |

+----+----------+----------+

1 row in set (0.00 sec)

mysql> select * from t_user where username = 0 and password = 'admin';

+----+----------+----------+

| id | username | password |

+----+----------+----------+

| 1 | admin | admin |

+----+----------+----------+

1 row in set (0.00 sec)

mysql> select * from t_user where username = '0' and password = 'admin';

Empty set (0.00 sec)

为什么第2个sql会查询到结果？

mysql> select * from t_user where username = 0 and password = 'admin';

+----+----------+----------+

| id | username | password |

+----+----------+----------+

| 1 | admin | admin |

| 2 | test | admin |

+----+----------+----------+

2 rows in set (0.00 sec)

结果是所有password='admin'，那么username=0呢？