title: Mysql - how to use like on multiple columns
body: <p>I've searched in mysql query a word in multiple column in java program. The number of column is variable.
  It is correct this query:</p>
  
  <pre><code>select * from customer with (city, name) like%'adelaide'%
  </code></pre>