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'