Monday 22 May 2017

How would you select all the users, whose phone number is null in MySQL

MySQL ISNULL function is used to get null values from MySQL table. Here is sample usage.
SELECT user_name FROM users WHERE ISNULL(user_phonenumber);

No comments:

Post a Comment

Advertisement

Advertisement