title: How do I normalize my current database structure
body: <p>I got headache to get a correct result when using <code>FIND_IN_SET</code> or <code>LIKE</code>. </p>
  
  <p>Example my value in database like this <code>1,2,3,4,5,6,7,8</code>.</p>
  
  <p>Lets say I have one form with many checkboxes. Each checkbox is coming with dynamic value which can add by users. Example value is colors and have <code>green, yellow, white, black, red, pink, brown, etc...</code></p>
  
  <p>My current structure <code>tbl_colors</code> &amp; <code>tbl_users</code></p>
  
  <pre><code>color_id  color_name
  ----------------------
  1         yellow
  2         black
  3         green
  .         ...
  .         ...
  20        pink
  </code></pre>
  
  <p>tbl_users</p>
  
  <pre><code>user_id  color_id
  ----------------------
  1         1,2,3,4
  2         3,4,5,6,8,9,10
  3         1
  .         ...
  .         ...
  20        1,10,20
  </code></pre>
  
  <p><strong>Question</strong></p>
  
  <p>How do I normalize &amp; restructure my current database above and easy me to count how much users like yellow color, brown color etc..</p>