The Song Fight Bulletin Board

So there's a website that turns lyrics into a word cloud. http://www.wordle.net/
It analyzes the word frequency and places them in a random design where the bigger words are more frequent and the tiny words less.

Additionally, I have all of my lyrics on a private wiki because I'm a crazy person. To grab all of the pages texts I ran this SQL query:
select CONVERT(wiki_page.page_title USING utf8), CONVERT(wiki_text.old_text USING utf8)
FROM wiki_page
INNER JOIN wiki_revision
ON wiki_page.page_latest=wiki_revision.rev_id
INNER JOIN wiki_text
ON wiki_revision.rev_text_id=wiki_text.old_id

And then proceeded to clean up the result.

Well, here's one of the images it generated.

Yeah, we have a thread here with that and multiple people made one. I think it was back when the interwebz was invented.

I can bet that thread did not include such an awesome SQL statement.

You can also bet I don't know what SQL means.

Either way, it's cool how it does that. Now I can scratch that off my "they can put a man on the moon, but they can't make song lyrics into a collage" list.

Manhattan Glutton wrote:I can bet that thread did not include such an awesome SQL statement.

Neither does this one.