MYSQL query statement for empty field

Question

My database contains data as per the sample below. I would like to select the red highlighted row. Tried this query but doesn't display the row that I wanted. Any help is very much appreciated.

<?php

mysql_connect("localhost", "xxxxx", "xxxxx") or
die("Could not connect: " . mysql_error());
mysql_select_db("xxxxx");

$result = mysql_query("SELECT * FROM tablename");

$row = mysql_fetch_array($result);

if($row['imageurl'] == 0){
echo $row['email'];
}

mysql_free_result($result);

?>

Code above will return '[email protected]'.

enter image description here

Community · Accepted Answer · 2017-05-23 12:07:01Z

1

Do you mean?:

SELECT * 
FROM tablename
WHERE imageurl IS NULL

If you want all results and test for NULL in PHP, see this question.

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered Jan 10, 2012 at 7:58

ypercubeᵀᴹ

116k19 gold badges181 silver badges248 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andreas Wong · Accepted Answer · 2012-01-10 08:00:00Z

1

Any reason on not doing it from query level?

"SELECT * From tablename where length(imageurl) = 0 or imageurl is null"

answered Jan 10, 2012 at 8:00

Andreas Wong

60.7k19 gold badges112 silver badges123 bronze badges

Comments

DhruvPathak · Accepted Answer · 2012-01-10 07:58:38Z

0

change this line :

if($row['imageurl'] == 0){

to :

if(empty($row['imageurl']) == true){

This will check if the imageurl is an empty string or null, as you want .

answered Jan 10, 2012 at 7:58

DhruvPathak

43.4k17 gold badges125 silver badges180 bronze badges

Comments

fyr · Accepted Answer · 2012-01-10 07:59:15Z

0

Probably the following statement solves your task:

SELECT * FROM TABLE WHERE imageurl IS NULL

answered Jan 10, 2012 at 7:59

fyr

21k7 gold badges40 silver badges54 bronze badges

Comments

jogesh_pi · Accepted Answer · 2012-01-10 07:59:32Z

0

if(empty($row['imageurl'])){
echo $row['email'];
}

answered Jan 10, 2012 at 7:59

jogesh_pi

9,7745 gold badges40 silver badges65 bronze badges

Comments

user1092803 · Accepted Answer · 2012-01-10 08:05:55Z

0

If the field is just empty (and not NULL) try:

SELECT * FROM TABLE WHERE length(imageurl) = 0

answered Jan 10, 2012 at 8:05

user1092803

3,3072 gold badges36 silver badges36 bronze badges

Collectives™ on Stack Overflow

MYSQL query statement for empty field

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related