[erlang-questions] Case-insensitive matching in mnesia and erlang

Christian <>
Sat Oct 18 00:50:03 CEST 2008


You convert your key to either all uppercase (or lowercase) on
inserting the record, then you do the same conversion on the key used
on lookup. This is the faster way. Not the fastest.

> I had the following question - I'm storing string data in an mnesia
> database as either a list of integers or as binaries. I want to find
> records using case-insensitive matching against this field. How would I
> use  mnesia:select to do this? Do I have to explicitly retrieve each
> record and convert the field and seach key to lower case myself and
> compare? Is there a faster way?
>
> /Ashok
> _______________________________________________
> erlang-questions mailing list
> 
> http://www.erlang.org/mailman/listinfo/erlang-questions
>



More information about the erlang-questions mailing list