[SOLVED] I am doing something wrong in this query, but I have no idea what. . .

[2tonejoe]

here is the mysql commad:

mysql> select ver1, ver2, ver3, ver4, ver5, ver6, ver7, ver8, ver9, ver10 from comp_book_info where ver1, ver2, ver3, ver4, ver5, ver6, ver7, ver8, ver9, ver10 != NULL;

 

and the error that I am getting is:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' ver2, ver3, ver4, ver5, ver6, ver7, ver8, ver9, ver10 != NULL' at line 1

 

i need to count how many ver* I get back that aren't NULL, but I am not getting anything back. . . . . I am attaching a screenshot of the table. . any ideas?

 

[attachment deleted by admin]

[amites]

I could be off but I think your where statement is bad

 

try

 

select ver1, ver2, ver3, ver4, ver5, ver6, ver7, ver8, ver9, ver10 from comp_book_info
where ver1 != NULL AND ver2 != NULL AND ver3 != NULL;

[2tonejoe]

thanks!