I use mysql version 3.23.58.
I want to use 'decode' and 'encode' functions:
http://dev.mysql.com/doc/mysql/en/E..._functions.html
Using password I can decode and encode data in mysql.
Below is my queries that return nothing:
#1 create table.
#2 insert data using encode function
#3 trying to select data from database using decode function
Return nothing.
Why the last query returns nothing?
mysql> create table t (a blob, b int(10));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into t values (encode('test','mypass'),121);
Query OK, 1 row affected (0.00 sec)
mysql> select * from t;
+------+------+
| a | b |
+------+------+
| �Yd | 121 |
+------+------+
1 row in set (0.00 sec)
mysql> select * from t where a = decode('�Yd','mypass');
Empty set (0.00 sec)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
