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

Question

python的烧瓶代码

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'] 如果选择了 2 个复选框，其中查询不起作用，否则 [str] 有 ['Building1'] 如果选择了 1 个复选框并且它有效 帮助我处理多个复选框 提前致谢

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>

标签： pythonhtmlmysqlflask