mysql多条件不定查询

SELECT * FROM products 
WHERE brand = 'Apple' AND price BETWEEN 5000 AND 10000;

import mysql.connector

def dynamic_query(brand=None, min_price=None, max_price=None):
    conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
    cursor = conn.cursor()
    
    query = "SELECT * FROM products WHERE 1=1"
    params = []
    
    if brand:
        query += " AND brand = %s"
        params.append(brand)
    
    if min_price:
        query += " AND price >= %s"
        params.append(min_price)
    
    if max_price:
        query += " AND price <= %s"
        params.append(max_price)
    
    cursor.execute(query, params)
    result = cursor.fetchall()
    
    cursor.close()
    conn.close()
    
    return result