title: Search whole spreadsheet to find text within a cell and then print the whole row
body: <p>I have a Google Sheets that contains several rows and columns of data and would like to search for a certain phrase in each row of the spreadsheet and then print the row out on a new sheet if that row contains the phrase in one of the columns of data (lets say column D).</p>
  
  <p>My sheet containing all the data is creatively called "All the data". Similarly, my sheet which will contain only the selected data is called "Selected data". 
  Lets say the phrase I am looking for is "hello".</p>
  
  <p>At the moment in the "Selected data" sheet, I have the following in cell A1:</p>
  
  <pre><code>=QUERY('All the data'!A:D,"select find("hello",All the data!D:D)&gt;0")
  </code></pre>
  
  <p>This produces a parse error, I want it to print all the rows from the "All the data" sheet that contain "hello" in column D in the "All the data" sheet.</p>
  
  <p>What am I doing wrong?  Am I using the correct function?  Is there another easier function to use?  What is the correct formula?</p>
  
  <p>Ultimately I would like to convert this into a Google Apps Script.</p>