mysql 字段特殊字符_MySQL选择带有特殊字符的字符串

最新推荐文章于 2024-06-20 07:28:08 发布

勃蓝色

最新推荐文章于 2024-06-20 07:28:08 发布

阅读量644

点赞数

文章标签： mysql 字段特殊字符

本文链接：https://blog.csdn.net/weixin_36348900/article/details/113171373

版权

I'm having a problem selecting strings from database. The problem is if you have McDonald's in row and if you are searching with a string mcdonalds it wouldn't find any results. Any suggestions?

I forgot to mention that I'm using LIKE in WHERE sentence.

解决方案

If your search requirements are to ignore certain characters, you can remove them during a search by replaceing them with a blank.

This answer solves your problem:

SELECT *

FROM restaurants

WHERE replace(name, '''', '') like '%mcdonalds%'; -- This will match "McDonald's"

FYI, a single quote literal (') is written as a doubled single quote (''), so to specify a single quote as a parameter to replace you need four quotes in a row ('''') - two at each end and the doubled quote in the middle for the actual quote.