Concat or +

[sebes]

hello,

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.

 

[feherke]

Hi

Only [tt]concat()[/tt] or [tt]concat_ws()[/tt] ( or maybe [tt]group_concat()[/tt] ).

Using [tt]+[/tt] for string concatenation is MSSQL's proprietary syntax.

The standard concatenation operator is [tt]||[/tt], but in MySQL that one is used as synonym for logical [tt]or[/tt].

Feherke.

 

[sebes]

That's sad...

Thanks.