怎样才能从user表中查询user_phonenumber字段为null的user_name数据?
SELECT user_name FROM users WHERE user_phonenumber;
这些语句都可以,取决于使用的MySQL版本。
SELECT user_name FROM users WHERE user_phonenumber IS NULL;
SELECT user_name FROM users WHERE user_phonenumber = NULL;