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

Question

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

Answer 1

改成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;

Answer 2

报错是什么？

要不要用一个等号试试？