title: Mysql query with keywords
body: <p>Here is my query to mysql with php;</p>
  
  <pre><code>$keywords = "keywords LIKE'%keyword1%' OR keywords LIKE'%keyword2%' OR keywords LIKE'%keyword3%'";
  
  mysql_query("SELECT * FROM table1 LEFT JOIN table2 ON table1.cat = cat.CATID WHERE category = '$catid' and ($keywords) limit 12");
  </code></pre>
  
  <p>What i wanna do is search keywords in keywords row with or statement but my problem is first keyword always full the 12 limit so i am only searching for 1 keyword with this code.</p>
  
  <p>I wanna find maximum 2 results per keyword...Am i going to do it with PHP or is there a way to accomplish this with MYSQL query?</p>