jd2007 Posted July 14, 2007 Share Posted July 14, 2007 How do i get the number of all rows which is not null in a particular column in a mysql table ? Quote Link to comment Share on other sites More sharing options...
chronister Posted July 14, 2007 Share Posted July 14, 2007 SELECT * FROM table_name WHERE column_name!='NULL'; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.