There is a request:

SELECT CONCAT('SELECT ', (SELECT GROUP_CONCAT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='u0415445_game' AND TABLE_NAME='users' AND COLUMN_NAME NOT IN ('id', 'nickname', 'steamid') ORDER BY ??? ), ' FROM users');

How to sort it (ORDER BY) alphabetically?

  • just write there clumn_name or alphabetically in which column you want to sort. Also note that order by is not to be specified at the end of the request, but inside the group_concat brackets (he understands this) - Mike
  • Agree with Mike user. ORDER BY designed to sort everything by / against the alphabet :). Just enter the name of the column instead ??? and you will be happy;) - Egor Randomize

0