title: MySQL: search in two columns
body: <p>how to search in two columns for string:</p>
  
  <p>user table: (structure)</p>
  
  <pre><code>id     first_name     last_name
  1         John         Adam
  2         Chris        Pratt
  3         Tom          keene
  4         Sarah        April
  5         Nina         Lora
  </code></pre>
  
  <p>how to search in both "first_name" and "last_name" for string, ex:</p>
  
  <pre><code>search phrase "pra"
  return 
  uid =&gt; 2
  </code></pre>
  
  <p>thanks,</p>