python中sql % 模糊查询

python中sql % 模糊查询

SELECT fileid
    FROM files
    WHERE description LIKE '%%%s%%'
        OR filename LIKE '%%%s%%'
        OR uploader LIKE '%%%s%%'
        ORDER BY fileid DESC" % (search, search, search)

Original: https://www.cnblogs.com/mxh1099/p/10093777.html
Author: 半天的半天
Title: python中sql % 模糊查询

原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/6577/

转载文章受原作者版权保护。转载请注明原作者出处!

(0)

大家都在看

最近整理资源【免费获取】:   👉 程序员最新必读书单  | 👏 互联网各方向面试题下载 | ✌️计算机核心资源汇总