I have a users table and I want to query the usernames column.  I want
my query to ignore the upper/lower casing.

So the following searches should all match "John":  "john", "jOhn",
"johN, "JOhn", and so on.

My query at the moment is a follows:
  names = queryselect(users.c.username.startswith("john"))

How can I modify the query to obtain the above results?

Thanks


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to