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
_______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
