Filter query Sqlalchemy

python Share on :

Sqlalchemy query to filter rows of a table created using Sqlalchemy ORM.

#SINGLE CONDITION
session.query(User).filter(User.id == 10).all()

#MULTIPLE CONDITION
session.query(User).filter(User.first_name == 'hello', User.last_name == 'world').first()

#LIKE QUERY
session.query(User).filter(User.name.like('e%')).all()

Search Index Data (The code snippet can also be found with below search text)

WHERE clause using Sqlalchemy

Contribute to this Snippet

Was this helpful?

Created by :

@

Write your Comment

0 Comments

Similar code snippets

Using OR on filter query SQLAlchemy
Using and on filter query SQLAlchemy
Filter based on NULL Values in SQLAlchemy
Filter by current time - n hours SQLAlchemy
Join models or tables query Sqlalchemy
Like query Sqlalchemy
Left Join Query python Sqlalchemy

Create your own code snippets and search them using our portal and chrome extension

Programming Feeds

Learn something new everyday on Devsheet

Important Links

Join Devsheet Create new snippet Ask a Question Write an article Online JSON Viewer