You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/08/23 06:29:04 UTC

[GitHub] [shardingsphere] xinglijun1973 commented on issue #20435: How to support the fuzzy query of encrypted fields

xinglijun1973 commented on issue #20435:
URL: https://github.com/apache/shardingsphere/issues/20435#issuecomment-1223609732

   @cheese8 if `fuzzyAlgorithm ` is fixed, such as `phone like ‘%<last four digits of mobile phone number>’`, it will do. but what if `company_name like '%sphere%'`? although, I think it  works for some fixed fuzzyAlgorithm.
   And another way, I think we can write db function in java, decrpt and do `like`, but I know Oracle and PG support java function, but My sql doesn'nt.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org