How to locate all the tables that have a field named username
I found it...

SELECT table_name, column_name, data_type, ordinal_position 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE table_schema = 'dbname' AND column_name LIKE '%username%';