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 = "SELECT * FROM T_SECTION WHERE TITLE LIKE '%s'" % ('%%%s%%' % sel) cur.execute(sql) data = cur.fetchall()
sql = "SELECT * FROM T_SECTION WHERE TITLE LIKE '%%%%%s%%%%'" % sel cur.execute(sql) data = cur.fetchall()