SQL to query equally named colons on DB
Handy dandy SQL query to find non-foreign-key related searches:
SELECT
TABLE_TYPE,
isColumns.TABLE_NAME,
COLUMN_NAME,
COLUMN_TYPE,
COLUMN_KEY,
IS_NULLABLE,
COLUMN_DEFAULT
FROM
INFORMATION_SCHEMA.COLUMNS as isColumns
inner join INFORMATION_SCHEMA.TABLES as isTables on ( isColumns.table_name = isTables.table_name )
WHERE
isColumns.table_schema = ‘YOURDATABASA’ AND
column_name LIKE ‘%WILD%’;