bbpassword Query

[digitalstudio]

Hi.

I need to write a query that takes the value of the "bbpassword" cookie and checks it against the user table "password" field.

The query will look something like this:

PHP Code:

$stmt = "SELECT user.`userid` 
         FROM `user` 
         WHERE `password` = '" . md5($_COOKIE['bbpassword'])  . "' "; 


My question is: Which functions do I need to run of the bbpassword cookie value to check it against the password field? As I'm pretty sure md5() isn't the only one!

Thanks.