您的查询可以如下所示：

select 
      table_name, table_schema, column_name 
from information_schema.columns
where table_schema in ('schema1', 'schema2') 
and column_name like '%column_name%'
order by table_name;

你一定能通过考试 column_name 作为参数（从python代码中获取）动态运行它。

import MySQLdb

#### #GET COLUMN NAME FROM USER PRESENT WITH IN TABLE

column = input()

#### #Open database connection

db = MySQLdb.connect("host","username","password","DB_name" )

#### #prepare a cursor object using cursor() method

cursor = db.cursor()

#### #execute SQL query using execute() method.

cursor.execute("SELECT * FROM TABLE")

# Fetch a all rows using fetchall() method.

result_set = cursor.fetchall()

for row in result_set:
    print(row[column])

# disconnect from server

db.close()

或者可以使用.execute（）运行具有列名的特定查询。