MattSandy
10/27/2015 - 5:16 PM

Grab all columns from rows matching prefix.

Grab all columns from rows matching prefix.

SELECT `TABLE_NAME`,`COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='wordpress' 
    AND `TABLE_NAME` LIKE 'wp_%';