RT,mysql中我用此语句居然无法查出结果本应该显示的一条结果。mysql> select * from mailMatchNumber;
+-------------+-------------+-------------+
| matchnumber | mailf | mailm |
+-------------+-------------+-------------+
| 111 | [email protected] | [email protected] |
+-------------+-------------+-------------+
1 row in set (0.00 sec)mysql> select * from mailMatchNumber where mailf='[email protected]';
Empty set (0.00 sec)
这是为什么?
+-------------+-------------+-------------+
| matchnumber | mailf | mailm |
+-------------+-------------+-------------+
| 111 | [email protected] | [email protected] |
+-------------+-------------+-------------+
1 row in set (0.00 sec)mysql> select * from mailMatchNumber where mailf='[email protected]';
Empty set (0.00 sec)
这是为什么?
这样却可以,是mysql对字符串中的数字有什么要求吗?
mysql> select * from mailMatchNumber;
+-------------+-------------+-------------+
| matchnumber | mailf | mailm |
+-------------+-------------+-------------+
| 111 | [email protected] | [email protected] |
| 222 | [email protected] | [email protected] |
+-------------+-------------+-------------+
2 rows in set (0.00 sec)mysql> select * from mailMatchNumber where mailf = '[email protected]';+-------------+------------+------------+
| matchnumber | mailf | mailm |
+-------------+------------+------------+
| 222 | [email protected] | [email protected] |
+-------------+------------+------------+
1 row in set (0.01 sec)
damn。