mysql选择不唤醒varchar字段 [英] mysql select not woking for varchar field

问题描述

我有带有varchar类型的电子邮件字段的表.

I have table with email field of type varchar.

select * 
from `table_name` 
WHERE email='some email'

除表中的一封电子邮件外，对其他所有电子邮件都有效.

working well for all the other email except one email in the table.

推荐答案

此方法可解决您有问题的记录

When this works for your problematic record

select * from table_name 
where email like '%some email%' 

然后，您的数据中就有前导或尾随空格.

Then you have leading or trailing spaces in your data.

要还原那样，更新现有的表数据

To revert that update your existing table data like this

update table_name
set email = trim(email)
where email like '%some email%' 

这篇关于mysql选择不唤醒varchar字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！