MySQL concat function

[cchko]

MySQL doesn't offer concat operators (||, +) but instead a concat() function.

Is it possible to call this with squeel? concat and __send__(:concat) don't appear to work.

Concat operators can be turned on in MySQL, but I'm interested in a solution that doesn't require that.

[cchko]

Just realized I can do this with a string.

select { "concat(users.last_name, ', ', users.first_name) as full_name" }