MySQL使用IF的时候出现预发错误上SQL-PHP中文网问答

文章专题 AI工具学习下载问答源码最近更新

PHP

会员中心讲师中心微信公众号

MySQL使用IF的时候出现预发错误上SQL

黄舟 2017-04-17 14:28:35

[MySQL讨论组]

321

SELECT a.user_id,a.user_name, a.email, IF(a.is_validated=='0','未验证','已验证'), a.user_money, 
a.frozen_money, a.rank_points, a.pay_points, a.reg_time FROM `jindong_users` AS a 
INNER JOIN jindong_account_log AS b
ON a.user_id=b.user_id
WHERE a.user_id=733

黄舟

人生最曼妙的风景，竟是内心的淡定与从容！

全部回复(2)

PHP中文网2017-04-17 14:30:35 2楼

改成1个等号就好，SQL中判断使用一个'='即可。

SELECT a.user_id,a.user_name, a.email, IF(a.is_validated='0','未验证','已验证'), a.user_money, 
a.frozen_money, a.rank_points, a.pay_points, a.reg_time 
FROM `jindong_users` AS a 
INNER JOIN jindong_account_log AS b ON a.user_id=b.user_id
WHERE a.user_id=733;