如果字段是AES_ENCYPTED,我将如何使用WHERE和LIKE serach执行MysqL SELECT?
例:
SELECT AES_DECRYPT(place,'"+salt+"'),AES_DECRYPT(web_address,'"+salt+"')
FROM access
WHERE place= LIKE '%(AES_ENCRYPT('"+searchStr+"','"+salt+"'))',%')
最佳答案
如果没有先解密,您就无法搜索加密列.
原文链接:https://www.f2er.com/mysql/433072.html你需要做WHERE AES_DECRYPT(比如,盐)LIKE’%something%’,但它会很慢.