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