I have just finished making a v3 for one of my scripts on my site and now I am running into a problem when trying to create the upgrader. See in v3 I used md5 encryption for passwords and etc, so I now need a query that I can run on my MySQL Database that will basically go through a specific table and take every entry for "passwrd" (yes passwrd not password) and md5 encrypt it and then re-enter it into the database.
I know how to do the basic selecting, deleting, updating, etc but I didn't know how I would go about doing this for an entire table.
Actual code would be great! Thanks in advance for any help!