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

Gleb Peregud <>
Sun Oct 19 10:06:59 CEST 2008


May you share with us the fastest way? :)

On 10/17/08, Christian <> wrote:
> 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
>>
> _______________________________________________
> erlang-questions mailing list
> 
> http://www.erlang.org/mailman/listinfo/erlang-questions
>

-- 
Sent from Gmail for mobile | mobile.google.com

Gleb Peregud
http://gleber.pl/

Every minute is to be grasped.
Time waits for nobody.
-- Inscription on a Zen Gong



More information about the erlang-questions mailing list