Quick-Tip: How to Search SQL/NoSQL/Postgres Information Schema in 1 Line

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE ‘%booty%’

This also works for table_name!