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
Post a Comment