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/26 04:04:31 UTC

[GitHub] [shardingsphere] princess-yanyan opened a new issue #15079: Query about "like"

princess-yanyan opened a new issue #15079:
URL: https://github.com/apache/shardingsphere/issues/15079


   ## Question
   
   **For English only**, other languages will not accept.
   
   Before asking a question, make sure you have:
   
   - Googled your question.
   - Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
   - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
   
   Please pay attention on issues you submitted, because we maybe need more details. 
   If no response anymore and we cannot reproduce it on current information, we will **close it**.
   
   I known encryption not support 'like', but i want to ask for advice,if the encrypt column need to query with ‘like’ what shuld i do？if you have some advice
   


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

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

Posted by GitBox <gi...@apache.org>.
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

[GitHub] [shardingsphere] terrymanu closed issue #15079: Query about "like"

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #15079:
URL: https://github.com/apache/shardingsphere/issues/15079


   


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

[GitHub] [shardingsphere] strongduanmu commented on issue #15079: Query about "like"

Posted by GitBox <gi...@apache.org>.
strongduanmu commented 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.


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