下面是模糊查找pass字段再加一个把查出来的列的数量从大到小进行排序并把数量显示出来select table_schematable_namecolumn_name from information_schemacolumns where column_name like pwd or column_name like pass

以下是模糊查找pass字段，并按列的数量从大到小排序并显示出来的SQL查询语句：

SELECT table_schema, table_name, column_name, COUNT(*) as column_count FROM information_schema.columns WHERE column_name LIKE '%pwd%' OR column_name LIKE '%pass%' GROUP BY table_schema, table_name, column_name ORDER BY column_count DESC;