Since LIKE %% searches are not possible, I am trying to figure out how to search for encrypted fields that might have a compound value.
For example if I have an encrypted last_name column that I would like to make searchable, what can I do so that a search for "jones" returns rows that have not only "jones", but also "edwards jones" and "smith-jones"?
My idea was to tokenize the values and create a blind index for each token, but I am a bit confused about the relationship between the index hash and it's name.
Do I just add a single blind index named last_name_idx and then repeatedly call getBlindIndex($token, "last_name_idx")?
Thank you.
Since LIKE %% searches are not possible, I am trying to figure out how to search for encrypted fields that might have a compound value.
For example if I have an encrypted
last_namecolumn that I would like to make searchable, what can I do so that a search for "jones" returns rows that have not only "jones", but also "edwards jones" and "smith-jones"?My idea was to tokenize the values and create a blind index for each token, but I am a bit confused about the relationship between the index hash and it's name.
Do I just add a single blind index named
last_name_idxand then repeatedly callgetBlindIndex($token, "last_name_idx")?Thank you.