Prevent mysql from returning null or empty fields

[derrick24]

Hi, I'm trying to prevent mysql from returning null or empty fields without specifying each field.

 

Im trying to do something like the following:

 

    SELECT (ONLY NON NULL FIELDS) FROM vine_details WHERE id = 12

 

for example.

 

???

 

 

[CroNiX]

SELECT field1, field2 FROM table WHERE id = 12 AND field1 IS NOT NULL AND field2 IS NOT NULL;

[fenway]

Why?

[derrick24]

Because I don't want to display blank fields to the end user, php generates the data from the returned result automatically and Id rather have mysql filter it out as apposed to php.

[fenway]

Because I don't want to display blank fields to the end user, php generates the data from the returned result automatically and Id rather have mysql filter it out as apposed to php.

Well, MySQL doesn't know that... so you'll have no choice but to do this in PHP.