/Python/Flask sqlalchemy case insensitive like

Flask sqlalchemy case insensitive like

Flask sqlalchemy case insensitive like

 my_string = 'BarFoo'
session.query(Foo).filter(func.lower(Foo.bar) == my_string.lower()).all()
#or
.query.filter(Model.column.ilike("ganye"))

0

Source: stackoverflow.com

Similar codes

0 vote103 views1 answer
How to import pygame onto python
Python
17 votes115 views3 answers
Matplotlib title
Python
0 vote110 views1 answer
Use a callable instead, e.g., use `dict` instead of `{}`
Python
1 vote99 views1 answer
How to write words on any other apps in python
Python
0 vote110 views1 answer
Converting 4hr 20min to minutes
Python
0 vote156 views2 answers
Extract email address using expression in django
Python Django
0 vote63 views1 answer
Python main.py
Python
2 votes103 views6 answers
How to merge more than 2 dataframes in python
Python
3 votes98 views1 answer
Python store save data
Python
0 vote100 views1 answer
Python () vs [] vs {\
Python

Share