title: How to select multiple values from one MySQL table column with PHP
body: <p>I have a MySQL table name <code>data_car</code>. The table data looks like this:</p>
  
  <pre><code>id   name      car
  1    john      BMW, Toyota 
  2    terry     Nixan, Toyota
  </code></pre>
  
  <p>My question how to select specific data from car. For example I have a combobox title car containing Toyota, BMW, Nissan, and I select Toyota so "name" person containing the value Toyota will show in my program.</p>
  
  <p>The output I want is as follows:</p>
  
  <pre><code>name: john      car:toyota    payment:$1000
  </code></pre>
  
  <p>But unfortunately when I select toyota in the combobox the result is always BMW, and always shows up like this:</p>
  
  <pre><code>name : john    car:toyota,BMW   payment:$1000
  </code></pre>
  
  <p>My question is can I just select the toyota value from that column?</p>