[CDBI] select lower(thing) from...

Howdy folks!

I've not seen anything to suggest this can be done in CDBI, but I
thought I'd give it a shot anyway.

I'm trying to do a case insensitive search on a column in a database.
I'm using SQLite, which doesn't appear to use ILIKE, so the recipe from
the cookbook for case insensitive searches won't work.

I would imagine that the best way to achieve this, it to convert my
search term to lower case, and SELECT LOWER(column) from the database
for the comparrison. Is there any way I could do this directly in
Class::DBI?

I suspect that I'll just be getting the DB handle and constructing my
own SQL here, but any suggestions are welcome.

-Oli

_______________________________________________
ClassDBI mailing list
ClassDBI-Ra3b/[email protected]
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFr5TfSbWXajvTQ+URApH4AJ9OnC3psPKf/ytJYsy6h4KV5WGvwQCfR4Oe
qhZ1igYQdWQ/OnkXa7NWK9E=
=xibq
-----END PGP SIGNATURE-----