title: PHP search function to look in pgsql table
body: <p>I want to make a search function in my website. I want to search for a string in all fields of my table (about 13 columns). If one row contains a field that matches the string (like operator) I want it to be added to result. </p>
  
  <p>Example </p>
  
  <pre><code>|field 1 | field 2 | field 3|
   some      string     test    
   test      some      string
   one       simple    string
  </code></pre>
  
  <p>Now basically if I search for the string "test" I want to have the first two rows. </p>
  
  <p>Is there a wildcard option for WHERE that I could do something : </p>
  
  <p>SELECT * from my.table WHERE * like '%string%';</p>