Using MD5 in MySQL -


i want use hash verify email existence. i've tried code , somehow doesn't work. there mistake or should elsewhere?

the code:

select id users md5(email+'*salt*')='*some value*' , checked='0' 

you don't use + concatenate strings. use concat:

select id users md5(concat(email,'*salt*'))='*some value*' , checked='0' 

Comments

Popular posts from this blog

c# - Unity IoC Lifetime per HttpRequest for UserStore -

I am trying to solve the error message 'incompatible ranks 0 and 1 in assignment' in a fortran 95 program. -

PHPMotion implementation - URL based videos (Hosted on separate location) -