python
Using and on filter query SQLAlchemy
We can apply AND operator on the SQLAlchemy filter query where it will filter the result if both conditions are matched.
from sqlalchemy import and_
session.query(
UserModel.id,
UserModel.first_name
).filter(
and_(
UserModel.first_name == 'john',
UserModel.last_name == 'michael'
)
).all()Was this helpful?
Similar Posts