mysql select语句，where like不返回结果

z3yyvxxp 于 2021-06-19 发布在 Mysql

关注(0)|答案(1)|浏览(336)

mysql语句在包含时不返回任何结果 WHERE LIKE .
声明：

SELECT aes_decrypt(SchoolName, 'MyString') as SchoolName from SchoolList Where aes_decrypt(SchoolName, 'MyString') LIKE '% Part of School Name Here%'

如果我移除 LIKE 它起作用了

SELECT aes_decrypt(SchoolName, 'MyString') as SchoolName from SchoolList Where aes_decrypt(SchoolName, 'MyString') = 'School Name Here'

mysql where-clause where

来源：https://stackoverflow.com/questions/52388703/mysql-select-statement-with-where-like-not-returning-results

1条答案

按热度按时间

lymgl2op1#

你需要把结果 aes_decrypt 为了使用 LIKE 操作员：

SELECT aes_decrypt(SchoolName, 'MyString') as SchoolName 
from SchoolList 
Where cast(aes_decrypt(SchoolName, 'MyString') as CHAR) LIKE '% Part of School Name Here%'

请参见此示例：https://www.db-fiddle.com/f/m1ynqmzvqss5ytetmrqubp/1

赞(0）回复(0）举报 2021-06-20

我来回答

mysql select语句，where like不返回结果

1条答案

相关问题

热门标签

最新问答