[Dbix-class] Best practice for case-insensitive searches

[Winfried Neessen]

Hi,

 

I'd like to do an case-insensitive search on one of my database tables
with DBIx::Class. As I haven't 

found any documentation about case-insensitive search, I am wondering
what's the best practice 

to do so.

 

What I would usually do with the regular DBI modul, is to create a
simple query like this:

SELECT t.id FROM table t WHERE LOWER( t.my_col ) = '<my search string>';

 

Any idea or thought-provoking impulse advise is much appreciated.

 

 

Thanks

Winni

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20110126/13221a3a/attachment.htm