Hi everybody --

Sorry this is such a basic question, but how can I GROUP BY the product of a CONCAT(), as in:

SELECT CONCAT(colnum1,colnum2)
FROM table
GROUP BY [the concatted thing]

I tried to name the product, but that didn't help. Does anyone have a clue? Thanks!