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