title: PHP: What is the best method to SQL query an array? (if you can)
body: <p>Consider this:</p>
  
  <p>One mySQL database that has tables and rows and data within it.</p>
  
  <p>One array that has the same data.</p>
  
  <p>Now normally, I would have a query like this for mySQL <code>SELECT * FROM 'table' WHERE name LIKE '%abc%'</code></p>
  
  <p>But I want to perform that same query on the array, without having to insert it yet. The only method that comes to mind is using <a href="http://php.net/manual/en/function.array-search.php" rel="noreferrer">array_search</a>, but the syntax is different and the method is convoluted. </p>
  
  <p>Is there a shortcut here?</p>