MySQL Select all items IS NOT NULL -

MySQL Select all items IS NOT NULL -

i have next structure:

//extra item1 item2 item3 1 2 null

with query everything:

selet * extra;

i homecoming results don't have null , don't want manually type each field these added @ time:

select * e e.sid = s.id , * not null

this fails.

if dont know names of columns . have this

show columns

you can utilize php array of columns got result . , can concat columns :

concat(<your list of columns>) not null

concat here returns null if of arguments null.

mysql