How's about:

SELECT count(sequenceId) AS timesUsed
FROM siteStats
WHERE keyWords IS NOT NULL
   <!--- may need this depending on design --->
    AND keyWords <> ''
GROUP BY keyWords

Heck, you may want to leave keywords in there when they're null/empty
string, just to see how often that happens.

-joe
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to