I've searched and think I'm getting closer but can't find answers which work. I have two problems to solve. Can anyone help? (1) I'm trying to convert a bunch of dates in a mysql db from varchar(20) eg. stored as "Aug 28, 2006" into int(10) format e.g. "1156741200" but can't figure out the sql query to run. (2) I have a table with user info in it. Passwords are stored there encrypted md5. I need to change everyone's password. I could generate a list of plain text random passwords and put them in a column next to the user id's. I'm not sure of how to get the md5 version of the random password that I give them. Also I'm guessing the sql query would be: Code: UPDATE table_name SET password=md5value WHERE user_id=some_value Any help really appreciated... my headache is now full blown!