How can I select and concat every field in a row? I want to do something similar to this: SELECT concat(SELECT GROUP_CONCAT(COLUMN_NAME)
which is ironic on two counts, 1) because concat(charfield, doublefield) works (it doesn\'t mind when one of the fields to be concatenated is numeric) and 2) because the mysql reference shows this:CON