MYSQL Query Help

Forum Moderators: open

Message Too Old, No Replies

12:21 am on Mar 22, 2007 (gmt 0)

Hi,
My Mysql4 DB is UTF-8 Unicode format however i need to run the following query

UPDATE user SET password = MD5(CONCAT(MD5('userpassword'), salt)) WHERE userid = 1

in latin1_swedish_ci. How do i modify the query? Thanks

12:19 pm on Mar 22, 2007 (gmt 0)

Typically CONVERT is used to do that:

UPDATE `table` SET `value` = '10' WHERE CONVERT( `setting` USING utf8 ) = 'amount' AND CONVERT( `value` USING utf8 ) = '1' LIMIT 1 ;

I just don't know where and what for you want to put it into your code,
but maybe it will give you an idea.

Regards
Michal