[erlang-questions] Case-insensitive matching in mnesia and erlang
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?
> erlang-questions mailing list
More information about the erlang-questions