MD5() i mysql

select COUNT(*) from users WHERE passhash=MD5(secret,'qwe',secret);

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''qwe',secret)' at line 1

select COUNT(*) from users WHERE passhash=MD5(secret+'qwe'+secret);

1 row in set, 5 warnings (0.00 sec)
| Warning | 1292 | Truncated incorrect DOUBLE value: 'password' | 
| Warning | 1292 | Truncated incorrect DOUBLE value: 'password' | 
| Warning | 1292 | Truncated incorrect DOUBLE value: 'password' | 
| Warning | 1292 | Truncated incorrect DOUBLE value: 'password' | 
| Warning | 1292 | Truncated incorrect DOUBLE value: 'password' |

1 row in set, 5 warnings (0.00 sec)
| Warning | 1292 | Truncated incorrect DOUBLE value: 'password' | 
| Warning | 1292 | Truncated incorrect DOUBLE value: 'password' | 
| Warning | 1292 | Truncated incorrect DOUBLE value: 'password' | 
| Warning | 1292 | Truncated incorrect DOUBLE value: 'password' | 
| Warning | 1292 | Truncated incorrect DOUBLE value: 'password' |

mysql> SELECT concat('ab','cd','ef');
+------------------------+
| concat('ab','cd','ef') |
+------------------------+
| abcdef                 |
+------------------------+
1 row in set (0.00 sec)