Ennovy.org

I’ve made so many words-related posts these days (or at least, I think I have) that I decided to create an entire category for them.

Also over the next few days I’m going to see how I can sort out all my posts. I want to assign each and every post to a category, and then I want to sort out the categories so that they are more meaningful. For example, I have a “Links” category right now, but almost every post I make has a link in it. That category is also huge.

To find all posts that don’t have a category assigned to it…
SELECT * FROM ‘pm_weblog’ WHERE ‘category’ = “”

To count number of posts in a category…
SELECT count(*) FROM ‘pm_weblog’ WHERE ‘category’ =65