查找当前schema下的所有类似字段

SELECT
table_name
,column_name
,column_type from information_schema.columns 
where table_schema = 'dev'
and column_name like '%PASSWORD%';