我正在 Flask 中做一條基于 url 中的搜索參數(shù)的路由,該路由將過濾數(shù)據(jù)庫返回所有類似的值,但我收到以下錯誤:near“%”:語法錯誤。有人可以幫忙嗎?@app.route('/courses/<search>', methods=['GET']) def searchg(search): con = sqlite3.connect('data.db') cur = con.cursor() courses = f'select id,name,description,tags,adminId,content,image from courses where name LIKE %{search}%' cur.execute(courses) allcourses=cur.fetchall() con.close() courseList = [] for c in allcourses: formattedcourses = {"id":c[0],"name":c[1],"description":c[2],"tags":eval(c[3]),"adminId":c[4],"content":eval(c[5].replace("#",'"')),"image":c[6]} courseList.append(formattedcourses) return jsonify(courseList),200
如何在sqlite中使用%和like值?
幕布斯6054654
2023-06-27 18:21:32