python-python中LIKE查询%问题

LIKE查询实现
1、方式一：
sql = "SELECT * FROM T_SECTION WHERE TITLE LIKE '%s'" % ('%%%s%%' % sel)
cur.execute(sql)
data = cur.fetchall()

2、方式二：
sql = "SELECT * FROM T_SECTION WHERE TITLE LIKE '%%%%%s%%%%'" % sel
cur.execute(sql)
data = cur.fetchall()

# SQL 查询语句
sel='我'
sql = "SELECT * FROM ARTICLE WHERE title = '%s' and cover LIKE '%%%s%%'" % ('我是中国人',sel)
print(sql)
try:
    # 执行SQL语句
    cursor.execute(sql,)
    # 获取所有记录列表
    results = cursor.fetchall()
    print(results)
except:
    print("Error: unable to fetch data")

注意：本文归作者所有，未经作者允许，不得转载