Este código é para buscar caracteres das colunas no banco inteiro:
SELECT
TABLE_NAME as tabela,
COLUMN_NAME as coluna,
CONCAT(LEFT(COLUMN_NAME,5),RIGHT(COLUMN_NAME,3)) as coluna_concat
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema = 'NOME_DO_BANCO'
AND CHARACTER_LENGTH(COLUMN_NAME) > 8
AND COLUMN_NAME NOT REGEXP ('_id|user_|fk_|userOpened|userClosed|dtModified|check_|dtSign')
AND TABLE_NAME NOT REGEXP ('user|_log|patient|log|profile|field_of_system|passwd|sub_visit|sign|queries|country|acl_request')
AND TABLE_NAME NOT LIKE 'visit'
ORDER BY tabela, coluna;