md5 with salt query help

[FD_F]

Hi,

 

i need to get the  file name was hashed and saved into mysql table

 

filename is the field with the file name in his real name

 

84cce6f10297af027e28fc779097eeb6 and 45436 comming from my php script

 

i did somthing like this:

 

 

SELECT * FROM table WHERE customer='45436' AND md5('lefttsalt + table.filename + rightsalt') = '84cce6f10297af027e28fc779097eeb6';

 

any idea to what i`m doing wrong ?

 

thanks in advanced

 

[FD_F]

solved

 

i spilt the query to tow parts

 

but if somone have idea how  to optimize  [now php doing the md5 job]