展开全部
利用information_schema.columns这个元数据32313133353236313431303231363533e59b9ee7ad9431333363393739表就行,查哪个数据库替换下test,或者就不加数据库限制,你自己改改SELECT
t.TABLE_SCHEMA,
t.TABLE_NAME,
t.COLLATION_NAME
FROM
information_schema.COLUMNS t
WHERE t.TABLE_SCHEMA = 'test'
AND (
BINARY t.COLUMN_NAME LIKE '%A%'
OR BINARY t.COLUMN_NAME LIKE '%B%'
OR BINARY t.COLUMN_NAME LIKE '%C%'
OR BINARY t.COLUMN_NAME LIKE '%D%'
OR BINARY t.COLUMN_NAME LIKE '%E%'
OR BINARY t.COLUMN_NAME LIKE '%F%'
OR BINARY t.COLUMN_NAME LIKE '%G%'
OR BINARY t.COLUMN_NAME LIKE '%H%'
OR BINARY t.COLUMN_NAME LIKE '%I%'
OR BINARY t.COLUMN_NAME LIKE '%J%'
OR BINARY t.COLUMN_NAME LIKE '%K%'
OR BINARY t.COLUMN_NAME LIKE '%L%'
OR BINARY t.COLUMN_NAME LIKE '%M%'
OR BINARY t.COLUMN_NAME LIKE '%N%'
OR BINARY t.COLUMN_NAME LIKE '%O%'
OR BINARY t.COLUMN_NAME LIKE '%P%'
OR BINARY t.COLUMN_NAME LIKE '%Q%'
OR BINARY t.COLUMN_NAME LIKE '%R%'
OR BINARY t.COLUMN_NAME LIKE '%S%'
OR BINARY t.COLUMN_NAME LIKE '%T%'
OR BINARY t.COLUMN_NAME LIKE '%U%'
OR BINARY t.COLUMN_NAME LIKE '%V%'
OR BINARY t.COLUMN_NAME LIKE '%W%'
OR BINARY t.COLUMN_NAME LIKE '%X%'
OR BINARY t.COLUMN_NAME LIKE '%Y%'
OR BINARY t.COLUMN_NAME LIKE '%Z%'
)