Tag Info

New answers tagged

1

Eventually I figured this out with help from this stack overflow post. SELECT CONCAT( 'SELECT `mytable`.Name', GROUP_CONCAT(CONCAT(' , `t_', REPLACE(Y, '`', '``'), '`.X AS `', REPLACE(Y, '`', '``'), '`' ) SEPARATOR ''), ' FROM `mytable` ', GROUP_CONCAT(CONCAT(' LEFT JOIN `mytable` AS `t_', REPLACE(Y, ...



Top 50 recent answers are included