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>