Questionaries.org
Login
Register
Questions
Unanswered
Tags
Users
Ask a Question
Welcome to Questionaries, where you can ask questions and receive answers from other members of the community.
Let us know at info@questionaries.org
How would you select all the users, whose phone number is null?
6
like
0
dislike
Hello
How would you select all the users, whose phone number is null?
please reply me. i am waiting for your reply.
Thanx
asked
1 year
ago
by
DBA-boss
(
120,990
points)
mysql
website
query
1 Answer
1
like
0
dislike
Best answer
SELECT user_name FROM users WHERE ISNULL(user_phonenumber);
answered
1 year
ago
by
eagles11
(
179,830
points)
Related questions
6
like
0
dislike
1
answer
How do you get the number of rows affected by query in SQL mysql?
asked
1 year
ago
by
DBA-boss
(
120,990
points)
rows
affected
query
sql
mysql
6
like
0
dislike
2
answers
How would you write a query to select all teams that won either 2, 4, 6 or 8 games?
asked
1 year
ago
by
DBA-boss
(
120,990
points)
website
mysql
6
like
0
dislike
1
answer
What does this query mean: SELECT user_name, user_isp FROM users LEFT JOIN isps USING (user_id)
asked
1 year
ago
by
DBA-boss
(
120,990
points)
mysql
website
php
4
like
0
dislike
1
answer
How would you change a column from VARCHAR(10) to VARCHAR(50)?
asked
1 year
ago
by
eagles11
(
179,830
points)
website
xml
mysql
6
like
0
dislike
1
answer
When would you use ORDER BY in DELETE statement?
asked
1 year
ago
by
DBA-boss
(
120,990
points)
mysql
sql
website