On Mar 10, 2008, at 4:01 AM, Acm wrote:
>
> I am working with SQLAlchemy 0.4.3
>
> In the 0.4 documentation, the way to query using the SQL LIKE operator
> is as follows:
> addresses.c.email_address.like('[EMAIL PROTECTED]')
>
> Does this work for the ILIKE operator as well?
> e.g. addresses.c.email_address.ilike('[EMAIL PROTECTED]')
>
> or should I use the previous way (that worked in 0.3.11) as in
> scanreport_def.c.filename.op('ilike')("%.exe")
somecol.ilike('foo') was added as of 0.4.3. note that "ilike" is not
availalbe on all databases, where it compiles to lower(x) like lower(y).
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
