Hello. I'v got an problem
I have a string like 'john' and I need to get results for 'john, JOHN'
etc. How to do that?
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe
On 6/23/2010 5:28 AM, Alexander Zhabotinskiy wrote:
Hello. I'v got an problem
I have a string like 'john' and I need to get results for 'john, JOHN'
etc. How to do that?
I think perhaps the ilike() filter operator might be the only way? It
might even depend on your back-end.
Hi Alexander,
On 23/06/2010 12:28, Alexander Zhabotinskiy wrote:
Hello. I'v got an problem
I have a string like 'john' and I need to get results for 'john, JOHN'
etc. How to do that?
I do it like this. force db column and search string to upper and I put
a % before and after the search