我正在使用Python一个用于MySQL的MySQL驱动程序,试图用两个参数消除函数中的重复代码: title,author。我正在尝试动态修改查询以适应用户输入。尽管查询是合法的,但通配符%s显然不适用于它。author = 'ANY (SELECT author FROM book)'
cursor.execute("SELECT * FROM book where title = %sand author = %s"
/db/backends/mysql/base.py", line 128, in execute File "/Users294, in _do_query_mysql_exceptions.ProgrammingError: (1064, "You have an error in yournear '%s AND `django_cont