[SOLVED] How do I select only fields that have data?

[gnawz]

Hi,

 

Any one know how to write a MySQL SQL that selects fields that are not blank based on a condition?

 

eg a database that has many columns that are all inserted into or updated at different times; meaning at some poit some fields are updated while others remain blank.

 

When I select, I only want to see fields that are not empty.

[JonnoTheDev]

Fields that are empty should be NULL

Then you can include

WHERE !ISNULL(field)

in your query

[Fadion]

Alternatively u can use the following snippet to test for null values:

<?php
$results = mysql_query("SELECT name FROM users WHERE name IS NOT NULL");
?>

 

That would normally require to have that field set as NULL. If u havent (u should), then a simple string compare will do:

<?php
$results = mysql_query("SELECT name FROM users WHERE name != ''");
?>