SQLAlchemy equivalent to SQL LIKE statement

Question

A tags column has values like  apple banana orange  and  strawberry banana lemon   I want to find the SQLAlchemy equivalent statement to  SELECT   FROM table WHERE tags LIKE   banana      What should I pass to Class query filter   to do this

User · Accepted Answer

Each column has like   method  which can be used in query filter    Given a search string  add a   character on either side to search as a substring in both directions   tag   request form  tag   search          format tag  posts   Post query filter Post tags like search   all

User · Answer

Using PostgreSQL like  see accepted answer above  somehow didn t work for me although cases matched  but ilike  case insensisitive like  does

User · Answer

If you use native sql  you can refer to my code  otherwise just ignore my answer  SELECT   FROM table WHERE tags LIKE  quot  banana  quot    from sqlalchemy import text  bar tags    quot banana quot         attention to spaces query sql    quot  quot  quot SELECT   FROM table WHERE tags LIKE      bar tags     quot  quot  quot     db is sqlalchemy session object tags res list   db execute text query sql     quot bar tags quot   bar tags   fetchall

User · Answer

try this code  output   dbsession query  lt model class gt   filter  lt model calss gt  email ilike        lt  email  gt

User · Answer

Adding to the above answer  whoever looks for a solution  you can also try  match  operator instead of  like   Do not want to be biased but it perfectly worked for me in Postgresql  Note query filter Note message match  quot  somestr  quot    all    It inherits database functions such as CONTAINS and MATCH  However  it is not available in SQLite  For more info go Common Filter Operators

[python] SQLAlchemy equivalent to SQL "LIKE" statement

Examples related to python

Examples related to sqlalchemy