Page 1 of 1

Get record with no value

Posted: Fri Oct 08, 2004 1:36 pm
by hawleyjr
This is one of those questions where I know the answer...I just can't think of it.


I'm trying do a query that looks like this:

Code: Select all

SELECT features1,features2 from table where features1 !=''
features1 is text

I'm trying to get all records where features1 does not have any value. I've tried != null also but no luck...Any help?

Posted: Fri Oct 08, 2004 2:21 pm
by timvw
comparision is done with <> not !=

but null is special, and you should something like isnull. consult the manual ;)

Posted: Fri Oct 08, 2004 2:55 pm
by feyd

Code: Select all

IS NOT NULL

Posted: Fri Oct 08, 2004 4:48 pm
by Weirdan
timvw wrote:comparision is done with <> not !=
both will work with MySQL

Posted: Sat Oct 09, 2004 5:34 am
by twigletmac

Posted: Sat Oct 09, 2004 8:25 am
by John Cartwright
twigletmac wrote: The manual knows all...
the manual IS all