mysql query if value is empty

Question

I want to query out the first 20 results if category='art' and there is no value in image field.

Can I write an SQL query like this?

SELECT image,date,category FROM imagecart WHERE category='art' AND image != '' Order By date DESC LIMIT 0,20

That looks right, but depending on how "no image" is stored in your system, you may need ...AND Image IS NULL ORDER BY... instead. Your questions asks for "no value" but your query is filtering for "image is NOT empty"; which do you need? — user565869
– user565869, Commented Mar 29, 2011 at 22:34

p.campbell · Accepted Answer · 2011-03-29 22:34:55Z

6

Alternatively:

SELECT image,date,category 
FROM imagecart 
WHERE category='art' 
AND LENGTH(image) = 0 
ORDER BY  date DESC LIMIT 0,20

Modify as you need to check for nulls:

AND (LENGTH(image) = 0 OR image IS NULL)

answered Mar 29, 2011 at 22:34

p.campbell

101k70 gold badges263 silver badges326 bronze badges

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

1 Answer 1