Busca de Caracteres das colunas de todas tabelas do banco em SQL-Mysql com Expressão Regular

Posted on : by : admin

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;