mysql 简单的 where 子句不起作用？

Question

Database changed

mysql> select * from userinfo;
+-----------+----------+-----------------------+------------+
| firstname | lastname | username              | password   |
+-----------+----------+-----------------------+------------+
|  asif     |  kolu    |  ashufound            |  123456    |
|  faisal   |  samad   |  tfhgfhgfh@gmail.com  |  123456    |
|  kamran   |  shafat  |  kamthemaam           |  kamoos    |
|  ubaid    |  mir     |  sadfsfsff@yahoo.com  |  qwertasd  |
|  majid    |  mir     |  zsffsa               |  afdfdsf   |
+-----------+----------+-----------------------+------------+
5 rows in set (0.00 sec)

mysql> SELECT  * from userinfo WHERE lastname = 'mir';
Empty set (0.10 sec)

mysql> SELECT  * from userinfo WHERE lastname='mir';
Empty set (0.00 sec)

这段代码有什么问题，简单的where子句不起作用？实际上问题出在我认为的插入代码中

Answer 1

您表格中的姓氏在 mir 前后可能有空格

   mir
  ^---^---look and remove spaces from here in your table