title: Storing repeated data into database
body: <p>What is a good way to store repeated varchars in a row of database.</p>
  
  <p>I have lots of repeated values in some columns and feels like there is a better way to do this. </p>
  
  <p>What I have in mind is something like assigning the column with an foreign key and do a join to get its value from a table called misc.</p>
  
  <p>Here is a illustration of what I have in mind:
  <a href="https://i.stack.imgur.com/vmiKB.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vmiKB.jpg" alt="enter image description here"></a></p>
  
  <p>Am I on the right track? Also, if I do it this way, how would I get the values of both columns.</p>
  
  <p>I'm using:
  PHP 5.5,
  MySQL 5.6</p>
  
  <p>In "Table 1" PK is an auto increment <code>INT</code>, and FK will be the PK of "Table 2" which is <code>misc_id</code> </p>