如何通过命令放入"IN"子句中的条件从数据库中获取结果？

SELECT * FROM table_name WHERE column_name IN ('value1', 'value2', 'value3');

import mysql.connector

# 连接到数据库
cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='database_name')
cursor = cnx.cursor()

# 定义查询
query = "SELECT * FROM table_name WHERE column_name IN (%s, %s, %s)"
values = ('value1', 'value2', 'value3')

# 执行查询
cursor.execute(query, values)

# 获取结果
result = cursor.fetchall()

# 关闭连接
cursor.close()
cnx.close()