SQLAlchemy中模糊查询，如何like多个关键字-灵析社区

from sqlalchemy import and_ words = ['%三%', '%猫%'] rule = and_(*[table.u_name.like(w) for w in words]) table.query.filter(rule)