利用python操作Mysql实现多个模糊查询条件,下面是代码
b=‘Z001B191108002R100’
con1=’%%’+b[0:14]+’%%’
con2=’%%’+b[16:]+’%%’
sql=""“SELECT * FROM report WHERE 字段1
like '”""+con1+"""’ and 字段2
like ‘""" +con2+"""’"""
self.cursor.execute(sql)
利用python操作Mysql实现多个模糊查询条件,下面是代码
b=‘Z001B191108002R100’
con1=’%%’+b[0:14]+’%%’
con2=’%%’+b[16:]+’%%’
sql=""“SELECT * FROM report WHERE 字段1
like '”""+con1+"""’ and 字段2
like ‘""" +con2+"""’"""
self.cursor.execute(sql)