How can I select columns with specific collation from mysql?

I wondering how can I select columns with specific collation.

For example, I want to select all the columns which their collation is utf-8.

How can I get these things done开发者_如何学C?

Thanks very much!

---

SHOW FULL COLUMNS is what you need:

SHOW FULL COLUMNS FROM xxx WHERE COLLATION = 'utf8_general_ci'