Another Solution:

SELECT CASE WHEN PASSWORD(?) = t1.passwd THEN 'true' ELSE 'false' END 
+FROM auth_table AS t1
[download]

There are a million ways to do it, the key is to let mysql encrypt the given password and compare that with the stored one.

Note, that if you are using MySQL >= 4.0.2, you should use the SHA1() function to encrypt passwords.