Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
malcolmboston
- DevNet Resident
- Posts: 1826
- Joined: Tue Nov 18, 2003 1:09 pm
- Location: Middlesbrough, UK
Post
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
-
malcolmboston
- DevNet Resident
- Posts: 1826
- Joined: Tue Nov 18, 2003 1:09 pm
- Location: Middlesbrough, UK
Post
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'
-
Weirdan
- Moderator
- Posts: 5978
- Joined: Mon Nov 03, 2003 6:13 pm
- Location: Odessa, Ukraine
Post
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>