[RESOLVED] How to use md5 with salt?

[sidsel]

In php I can do the following:

md5("some_input" . "123abc");

But how do I do it in mysql?

Trying something like this gives me a different hash string:
SELECT MD5(some_field + '123abc') FROM table

[Installer]

SELECT MD5(CONCAT(some_field, '123abc')) FROM table;