You can use the op method of a column to create a 'ilike' operator like this:
MyClass.c.column_name.op('ilike')('%something%') On 6/27/06, Julien Cigar <[EMAIL PROTECTED]> wrote:
Hi, Stupid question, is it possible to do a case insensitive like with SQLAlchemy (something like .ilike()) ? I haven't found anything in the doc about this Thanks, Julien Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-- Hong Yuan 大管家网上建材超市 装修装潢建材一站式购物 http://www.homemaster.cn
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users