How to use the filter operater of like in sqlalchemy?

Question

I want to query data from database use sqlalchemy, and the code is below:

    session.query(Person).filter(Person.name.like("%tom%")).all()

but this is case sensitive, in other words, the params of like is just match "tom" and dose not contain "TOM". How to deal with the query without case sensitive ?

Look at - http://stackoverflow.com/questions/16573095/case-insensitive-flask-sqlalchemy-query?answertab=votes#tab-top — a.m., Nov 11 '13 at 07:02

Leonardo.Z · Answer 1 · 2013-11-11T03:34:33.637

0

You can use sqlalchemy's built-in ilike.

e.g

select([sometable]).where(sometable.c.column.ilike("%foobar%"))

ILIKE is quasi-standard, it is supported by MySQL and PostgresQL.

edited Nov 11 '13 at 03:34

answered Nov 11 '13 at 03:28

Leonardo.Z

9,425
3
35
38

1

session.query(Person).filter(Person.name.ilike("%tom%")).all() seems to to be ok. – zimmer Nov 11 '13 at 05:44

How to use the filter operater of like in sqlalchemy?

1 Answers1