>I can't find an equivalent for concatenating two strings nicely with the "+" sign.
>
>Can I use something like this in MySQL ?
>
>Select string1 + string2 as field name ?
>
>OR do I have to use select concat(string1, string2) as fieldname ?
>
>Thanks.

Yes, that's the idea: Concat(String1, string2, etc)