如何将字符串数组发送到数据库并一次搜索一个值

import mysql.connector

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

# 准备数据
string_array = ['value1', 'value2', 'value3']
data = ','.join(string_array)

# 插入数据
cursor = cnx.cursor()
insert_query = "INSERT INTO table_name (column_name) VALUES (%s)"
cursor.execute(insert_query, (data,))
cnx.commit()

# 搜索数据
search_value = 'value2'
search_query = "SELECT * FROM table_name WHERE column_name LIKE %s"
cursor.execute(search_query, ('%' + search_value + '%',))
result = cursor.fetchall()

# 处理结果
for row in result:
    print(row)

# 关闭数据库连接
cursor.close()
cnx.close()