func.lower(my_table.c.my_column).like(my_variable.lower())
On Jun 8, 2006, at 12:11 PM, jeff emminger wrote:
> i'm trying to do a select using LIKE:
> my_table.c.my_column.like( my_variable.lower() )
>
> i need it to be case-insensitive on my_column... in sql this would be
> where lower(my_column) like lower('whatever')
>
> how can i do this in sqlalchemy?
>
>
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
