python mysql 查询(in 、 like)

python进行mysql多条件查询

基础sql

sql = "select * from table where 1 = 1 " 

in 条件添加

id_list_in为字符串

sql += " and id in (%s)" % ','.join(["'%s'" % id for id in id_list_in]) 

like 条件添加

name_in为字符串

sql += " and name like '%s%%%%'" % (name_in)