[Dbix-class] Best practice for case-insensitive searches
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...
More information about the DBIx-Class