Tell MySQL not to return NULL

[grippat]

Is there a way to tell MySQL to return no value whatsoever if a value in a column is NULL? When I do a select on a certain column it returns NULL for some rows and nothing for others. I'd rather have it be consistent.

[Ingolme]

I guess you should make the fields "NOT NULL" when you create the database table.

[Reg Edit]

Is there a way to tell MySQL to return no value whatsoever if a value in a column is NULL? When I do a select on a certain column it returns NULL for some rows and nothing for others. I'd rather have it be consistent.

Does MySQL have a COALESCE function? That's how you'd do it if it was MS SQL.