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

以下是根据模糊查找条件"pwd"或"pass"查询出的字段，并按数量从大到小进行排序：

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