3 messages in com.mysql.lists.mysqlCorrect syntax?
FromSent OnAttachments
Graham Nichols19 Apr 2001 10:35 
John Barton19 Apr 2001 11:07 
Braxton Robbason19 Apr 2001 11:16 
Subject:Correct syntax?
From:Graham Nichols (gra@contrast-software.com)
Date:04/19/2001 10:35:34 AM
List:com.mysql.lists.mysql

Thanks for help from this group I'm using

"select word, count(word) as total from search_words group by word order by total desc limit 20"

to locate the top 20 words in a database of website search engine words.

The database had been altered to include an extra column, other than the 'word' column. This means that 'word' can now have a null entry sometimes. How can I modify the sql query above to exclude any row(s) in 'word' with 'NULL' please?

regards, Graham l