OLD_PASSWORD(str): returns the value of the old (pre-4.1) implementation of PASSWORD() as a binary string. : OLD_PASSWORD « Encryption Compression Functions « MySQL Tutorial






mysql>
mysql> select OLD_PASSWORD("text");
+----------------------+
| OLD_PASSWORD("text") |
+----------------------+
| 379146d92233edb1     |
+----------------------+
1 row in set (0.00 sec)








19.12.OLD_PASSWORD
19.12.1.OLD_PASSWORD(str): returns the value of the old (pre-4.1) implementation of PASSWORD() as a binary string.
19.12.2.Using old_password to ENCRYPT the first name