Error using NOT in query...

pplers

I have a little bit of a problem in a mysql query. It is this one:

Expand|Select|Wrap|Line Numbers

 SELECT `id` FROM `table` WHERE `row1'`='something' AND `row2` NOT NULL;
 

How can i select values that verify `row1'`='something' but are not NULL ?

I tried ! , != and others but with no luck

mwasif

Use IS NOT NULL

Expand|Select|Wrap|Line Numbers

 SELECT `id` FROM `table` WHERE `row1`='something' AND `row2` IS NOT NULL;
 

pplers

thank you..

and sorry for that lame question

mwasif

No problem, post back whenever you need help.

re: Error using NOT in query...