title: MySQL - How can i query a multi-value field to match a primary key of another table?
body: <p>I have 2 tables. One table contains all of the states in the USA.  The other table is just a list of stuff in those states.</p>
  
  <p>My table is structure looks something like this:</p>
  
  <pre><code>tbl_states - stateID (PK), stateName
  tbl_stuff - stuffID, stuffName, relState
  </code></pre>
  
  <p>The values look like this</p>
  
  <pre><code>1 | Alabama
  2 | Georgia
  3 | Maryland
  </code></pre>
  
  <p>The relState column relates to the tbl_states.stateID column and i have it in this format. I plan to have a webform to select multiple states and assign the stuff in the states to the state.</p>
  
  <pre><code>1 | This is some stuff | 1,2 [ and this stuff is only AL, GA. ]
  </code></pre>
  
  <p>So I'm trying to figure out the best way to write the select statement for this. Is there some way to do it strictly with mysql? </p>