select cast( `columnname` as char)  from  `tablename`;