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

Winfried Neessen winfried at neessen.net
Wed Jan 26 16:25:49 GMT 2011



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.





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

More information about the DBIx-Class mailing list