Page 1 of 1

strange SQL problem

Posted: Thu Apr 13, 2006 6:55 am
by malcolmboston
ok, SQL is going crazy

this works

Code: Select all

SELECT * FROM `usr_table` 
WHERE `user_name` = 'mal' 
AND 
`user_pass` = '5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8' LIMIT 1
this fails

Code: Select all

SELECT * FROM `usr_table`
WHERE `user_name` = 'sam'
AND
`user_pass` = '5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8' LIMIT 1
gives the error

Code: Select all

unknown column 'sam' in 'where clause'
im completely baffled

Posted: Thu Apr 13, 2006 7:27 am
by malcolmboston
additional information, it seems to be due to something to do with the SHA256 string

fails:

Code: Select all

SELECT * FROM `usr_table` WHERE `user_name` = 'malcolmboston' AND `user_pass` = '5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8'
works:

Code: Select all

SELECT * FROM `usr_table` WHERE `user_name` = 'malcolmboston' AND `user_pass` = 'something'

Posted: Thu Apr 13, 2006 10:37 am
by Weirdan

Code: Select all

mysql> create table usr_table (user_name varchar(128), user_pass varchar(128));
Query OK, 0 rows affected (0.02 sec)

mysql> insert into usr_table set user_name='Weirdan', user_pass='5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8';
Query OK, 1 row affected (0.00 sec)

mysql> select * from usr_table;
+-----------+------------------------------------------------------------------+
| user_name | user_pass                                                        |
+-----------+------------------------------------------------------------------+
| Weirdan   | 5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8 |
+-----------+------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM `usr_table` WHERE `user_name` = 'malcolmboston' AND `user_pass` = '5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8' ;
Empty set (0.00 sec)

mysql> SELECT * FROM `usr_table` WHERE `user_name` = 'Weirdan' AND `user_pass` = '5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8' ; +-----------+------------------------------------------------------------------+
| user_name | user_pass                                                        |
+-----------+------------------------------------------------------------------+
| Weirdan   | 5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8 |
+-----------+------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select version();
+------------+
| version()  |
+------------+
| 4.0.25-log |
+------------+
1 row in set (0.00 sec)

mysql>