sql = 'select * from table where id like %s or name like %s '
value = ('%%%s%%' % id,'%%%s%%' % name)
# 执行sql语句
cursor.execute(sql,value)
sql = 'select * from table where id like %s or name like %s '
value = ('%%%s%%' % id,'%%%s%%' % name)
# 执行sql语句
cursor.execute(sql,value)