title: Solution for searching small/medium databases
body: <p>The databases to search will range from x100 to x1000 items.</p>
  
  <p>I need a search solution with PDO mysql and PHP that with best possible performance can match multiple keywords (match all) with multiple "searchable" columns in the table.</p>
  
  <p>What is the performance difference of limiting queries, limiting php loops etc.?</p>
  
  <p>I guess that in a smaller database such complex search would be made fast with fetching all in one query and filtering with php loops, but as soon as the db grows fetching all results every time must cause performance issues? This is considering that multiple queries need to be done for such search or can it be done in one query? With fulltext preferably.</p>