Use SHA1 to digest the message.
SHA(str) or SHA1(str)
str: content to be encryptedmysql> select sha("123"); +------------------------------------------+ | sha1('123') | +------------------------------------------+ | 40bd001563085fc35165329ea1ff5c5ecbdbbeef | +------------------------------------------+ 1 row in set (0.13 sec)
SHA,SHA1