not returning null values

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

not returning null values

Post by GeXus »

how do you not return null values? :)
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

By not storing them, by filtering them out in the where clause.. can you be a bit more specific?
paladaxar
Forum Commoner
Posts: 85
Joined: Fri Jun 18, 2004 11:50 pm

Post by paladaxar »

WHERE field_name IS NOT NULL;

Is that what you were looking for? Like feyd said, can you be a bit more specific? Just make sure you are not using equality with null's. Nothing is ever equal to null, nor can anything be greater than or less than null. It just is or it isn't.
Post Reply