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()
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()