From: Hank
Date: October 19 2012 3:57pm
Subject: Schemas for storing and reporting on hashtags
List-Archive: http://lists.mysql.com/mysql/228465
Message-Id: <CAPs4VGnDRtG-eEVeZWsWWpg0oZ4HBZLO-bM7fzmouJg0PT2HHQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1

Are there any established "best practices" or schemas for
incorporating twitter-like hashtags  into a database ?

Let's say I have a blog with a commenting system, and I want to allow
people to add hashtags to the comments.

I could certainly create one on my own (it's not that difficult), but
I'd like to see what other people have done in terms of storage and
features.

I'm also looking for a solid basic implementation, not something
overly complex.

Thanks,

-Hank

(query, mysql)