将整个搜索字符串作为参数传递给LIKE 运算符 :
results = db.execute(text("SELECt * FROM books WHERe title LIKE :search"), {"search": f"%{search}%"}).fetchall();
或串联在数据库中:
results = db.execute( text("SELECt * FROM books WHERe title LIKE ('%' || :search || '%')"), {"search": search}).fetchall();
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)