更新时间:2022-03-14 21:54:25
MySQL 的 REPLACE() 函数不区分大小写.
MySQL's REPLACE() function is not case-insensitive.
我发现这个博客是关于一个用户创建了一个存储函数来进行不区分大小写的字符串替换.这很尴尬.https://pento.net/2009/02/15/case-insensitive-replace-for-mysql/
I found this blog about a user who created a stored function to do case-insensitive string replace. It's awkward. https://pento.net/2009/02/15/case-insensitive-replace-for-mysql/
对于此任务,如果您有特殊的字符串比较要求,您可能会发现只需编写一个脚本来一次一行地完成它会更容易.
For this task, if you have special string comparison requirements, you might find it easier to just write a script to do it one row at a time.