I've been working in conjunction with a couple of other car related bulletin boards (as well as the FBI) at nabbing an unscrupulous individual, and I was wondering if there was a way to search the database for *passwords* and if any users use a certain password? The individual under investigation has several aliases, but ironically uses only 2 different passwords in all his travels...thanks in advance!

well since the passwords are md5'd you really can't see the actual password but you can see the hash.. so if you find a hash that he uses then you can search the w3t_Users table using that hash and searching on the U_Password field...

you could however try a

SELECT U_Username FROM w3t_Users
WHERE U_Password = DES_ENCRYPT('whatyalookingfor');

it may or may not work..