Well I ran some regexes through all the posts in database hoping to clean them up a bit, and got rid of all the instances where I was starting with an unnecesary paragraph tag, now that it’s all taken care of automatically. I also took out some things so my RSS feed should be cleaner now, or at least if I ever offer the old stuff up for syndication. I think I’ve reached the limit of what I can do with pure SQL, so I think I’m going to patch something together in PHP one of these nights. I basically just need to do the same thing except maybe strip_tags first. Then I can modify that to find if there’s any pattern to the words I start out with. How exciting!!! Hold on to your seats:

+--------+-------+
| letter | count |
+--------+-------+
| I | 116 |
| < | 65 |
| T | 49 |
| W | 42 |
| A | 17 |
| O | 14 |
| S | 13 |
| J | 10 |
| Y | 9 |
| M | 9 |
| H | 9 |
| F | 7 |
| D | 6 |
| C | 4 |
| G | 4 |
| E | 4 |
| L | 4 |
| B | 3 |
| P | 3 |
| N | 3 |
| V | 2 |
| . | 1 |
| U | 1 |
| " | 1 |
| 9 | 1 |
+--------+-------+
25 rows in set (0.00 sec)

(Of course I don’t really think that’s exciting.)