在python和mysql中使用like时出现警告1292

import mysql.connector

config = {
    'user': 'your_username',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database',
    'sql_mode': 'traditional'  # 设置为其他模式，如traditional
}

cnx = mysql.connector.connect(**config)

import mysql.connector

cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')

cursor = cnx.cursor()

pattern = 'some_pattern_with_backslash'
pattern = pattern.replace('\\', '\\\\')  # 将单个反斜杠替换为双反斜杠

query = "SELECT * FROM your_table WHERE your_column LIKE %s"
cursor.execute(query, (pattern,))

# 处理查询结果
for row in cursor:
    print(row)

cursor.close()
cnx.close()