title: Database design for apps using "hashtags"
body: <p>database design question here.</p>
  
  <p>Say we had a webapp or something that uses hashtags for 20-40 word notes. What is the best way to store a user's hashtags.</p>
  
  <p>For instance, if a user entered. <code>"I like to have #lunch at #sizzler"</code> we would store the sentence as text and we could store the hashtags as JSON, a comma separated list or some other mechanism.</p>
  
  <p>Its also worth pointing out that the tags need to be searchable, such as how many people have been hash tagging lunch, etc.</p>
  
  <p>Advise on the matter would be great, I always get a bit stumped when it comes to storing variable sized inputs in mysql. There can be an infinite number of hashtags per note, what is the best way to store them?</p>