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/01/28 05:49:56 UTC

[GitHub] [shardingsphere] strongduanmu edited a comment on issue #15079: Query about "like"

strongduanmu edited a comment on issue #15079:
URL: https://github.com/apache/shardingsphere/issues/15079#issuecomment-1023905303


   @princess-yanyan There is a way to use substring encryption now, and then use the same way to split and encrypt the query field to support like queries.
   
   For example, the value of encrypted field is 123456, we can split it according to length 4, and then get 1234, 2345, 3456 substrings, which are encrypted separately and then combined. When querying 12345, it will also be split into 1234 and 2345 substrings according to length 4, and then encrypted and combined to support fuzzy queries with length >= 4 query conditions.


-- 
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