如何使用复选框编写where子句为flask mysql中的同一列选择多个值

Question

python的Flask代码

cursor = conn.cursor()
            amin=request.form.getlist('interest')
            str1 = ','.join(amin)
            cursor.execute("SELECT * FROM emp_vehical_report WHERE Location IN (%s)",[str1])
            vehical_details=cursor.fetchall()
            rendered=render_template('Download.html',list=vehical_details,x=str1)

我需要从带有复选框位置的数据库中获取所有值 但我只在一个位置得到它，而不在其他选中的复选框中得到它

如果选中两个复选框，则基本上[str1]具有值['Building1，Building2'] 哪个查询不起作用 如果选中1复选框，则[str]具有['Building1']，并且该复选框有效 帮助我选择多个复选框 提前谢谢

HTML代码

 <div>
    <input type="checkbox" id="Building1" name="interest" value="Building1">
    <label for="Building1">Building 1</label>
  </div>
  <div>
    <input type="checkbox" id="Building2" name="interest" value="Building2">
    <label for="Building2">Building 2</label>
  </div>
  <div>
    <input type="checkbox" id="Building3" name="interest" value="Building3">
    <label for="Building3">Building 3</label>
  </div>
   <div>
    <input type="checkbox" id="Building4" name="interest" value="Building4">
    <label for="Building4">Building 4</label>
  </div>
   <div>
    <input type="checkbox" id="Building5" name="interest" value="Building5">
    <label for="Building5">Building 5</label>
  </div>
   <div>
    <input type="checkbox" id="AL" name="interest" value="AL">
    <label for="All Locations">All Locations</label>
  </div>