Skip to content

Instantly share code, notes, and snippets.

@mergeweb

mergeweb/gist:9aa53241fd9f819cc569

Created November 4, 2015 16:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mergeweb/9aa53241fd9f819cc569 to your computer and use it in GitHub Desktop.
Save mergeweb/9aa53241fd9f819cc569 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
select id,
(SELECT GROUP_CONCAT(`COLUMN_NAME` SEPARATOR ', ')
FROM `INFORMATION_SCHEMA`.`COLUMNS`
WHERE `TABLE_SCHEMA`='heavysalvage'
AND `TABLE_NAME`='auctions'
AND COLUMN_NAME LIKE '%rear_%')
from auctions order by cab DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment