SELECT CONCAT('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;') as stmt FROM `information_schema`.`TABLES` t WHERE 1 AND t.`TABLE_SCHEMA` = 'timphilbin' ORDER BY 1 ALTER TABLE * CHANGE * CHARACTER SET latin1 COLLATE latin1_swedish_ci WHERE COLLATE=utf8_general_ci