title: Mysql where clause (search where table column match)
body: <p>I have 1 table, <code>t1</code>, around 500+ data row, I just show a sample data.</p>
  
  <p>Data as below:</p>
  
  <pre><code>+--------+----------+-------------------+
  | id     | Name     | category          |
  +--------+----------+-------------------+
  | 1      | ABC      | 6,9,25,27         |
  +---------------------------------------+
  </code></pre>
  
  <p>My mysql query like below:</p>
  
  <pre><code>$gcategory = intval($_GET['cat']);
  $test = DB::fetch_all("SELECT * FROM t1 WHERE category like '%$gcategory%' ORDER BY id DESC");
  foreach($test as $te){
      $list[] = $te;
  }
  </code></pre>
  
  <p>But if <code>$gcategory = '7';</code> the <code>ABC</code> also will appear in my <code>$list[]</code>, but I just want when <code>$gcategory = '6' || $gcategory = '9' || $gcategory = '25' || $gcategory = '27'</code> then <code>ABC</code> only appear in my <code>$list[]</code>? how to fix this?</p>
  
  <p>Thanks.</p>