文章内容
2023/3/10 15:29:25,作 者: 黄兵
SQLAlchemy or、and、like查询举例
等于
query.filter(User.name == 'xxx')
不等于
query.filter(User.name != 'xxx')
like
query.filter(User.name.like('%xxx%'))IN查询
query.filter(User.name.in_(['leela', 'akshay', 'santanu']))
NOT IN 查询
query.filter(~User.name.in_(['lee', 'sonal', 'akshay']))
ISNULL
query.filter(User.name.is_(None))
IS NOT NULL
query.filter(User.name.isnot(None))
AND
from sqlalchemy import and_ query.filter(and_(User.name=='xxx', User.sex==1))
也可以用下面一种方式查询：
from sqlalchemy import and_ query.filter(User.name=='xxx').filter(User.sex==1)
OR
from sqlalchemy import or_ filter(or_(User.name == 'xxx', User.name == 'yyy'))
评论列表