SQL中的电子邮件比较 [英] Email comparison in SQL

问题描述

大家好，我正在做一个小项目，使用mysql来管理来自网站的供稿并向注册用户展示它们，样式Google Reader，后端我使用GO和DBMS MySQL，一切顺利，直到我想写一个查询来比较电子邮件地址，我介绍了一个电子邮件查询，样式是这样的：



SELECT id FROM User WHERE Email =[e-mail]<上面描述的


查询返回我的null，一个用户存在于带有这个邮件的表中，但当我做同样的查询比较其他字段如name时，用户正确地给我，有人有想法可能会在这里发生吗？，问候和谢谢...

Hello everyone, I am doing a little project using mysql to manage feeds from sites and show them to the registered users, style Google Reader, to backend I am using GO and DBMS MySQL, everything went smoothly until the moment I 'd write a query to compare email addresses, I introduced an email query, style something like this:

SELECT id FROM User WHERE Email = "[e-mail]"

described above query returns me null, a user exists in the table with this mail, but when I do the same query comparing other fields such as name, user puts me correctly, someone has idea that may be happening here ?, greetings and Thanks ...

推荐答案

两个问题：

1）用户是一个SQL关键字，所以用它作为你的表的名字有点傻......

2）不要使用双引号字符串，使用单引号和SQL。

试试这个：

Two problems:
1) User is an SQL Keyword, so using it for the name of your table is a little silly...
2) Don't use double quotes for a string, use single quotes with SQL.
Try this:

SELECT id FROM [User] WHERE Email = '[e-mail]'

错别字：叹息：[/ edit]

[edit]Typos... :sigh: [/edit]

一种可能是你不匹配上/下字符。尝试类似

One possibility is that you have a mismatch in upper/lower characters. Try something like

SELECT id FROM User WHERE lower(Email) = "[e-mail]"

这篇关于SQL中的电子邮件比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！