title: How to search multiple columns in MySQL?
body: <p>I'm trying to make a search feature that will search multiple columns to find a keyword based match. This query:</p>
  
  <pre><code>SELECT title FROM pages LIKE %$query%;
  </code></pre>
  
  <p>works only for searching one column, I noticed separating column names with commas results in an error. So is it possible to search multiple columns in mysql?</p>