I have the following model:
class Post(db.Model):
id = db.Column(db.Integer, primary_key = True)
title = db.Column(db.String(250))
content = db.Column(db.String(5000))
I'd like to run a query that selects all posts, case insensitive, that match '%' + [some_phrase] + '%'. That is, select all rows that have titles that contain some phrase, case insensitive. From the research I've done, it looks like I need to use Postgres's ILIKE query for it to match case insensitive. How can I execute a query like this with SQLAlchemy? Something along the lines of
Post.query.select.where(Post.title.ilike('%[some_phrase]%'))?
Thanks.
