How to find a table that has a column?

Question

MySQL

Good day. There is a column (or field) called pricetour, how do I find which table (column) it is in? The table is large, look is not an option. It is possible somehow request?
Thank you very much in advance.

Answer 1

SELECT `table_schema`, `table_name`
  FROM `information_schema`.`columns`
  WHERE `column_name` = 'pricetour'