title: Concat inside a WHERE clause in postgres
body: <p>I have a question about concat function in PostgreSQL. </p>
  
  <p>This sentence works well in MySQL: </p>
  
  <pre><code>SELECT * FROM words
   WHERE CONCAT (word,' ',gender,' ',semantic) LIKE '%"+value+"%'. 
  </code></pre>
  
  <p>Value is a variable that is changed inside my Java program. </p>
  
  <p>But I need the same working in postgresql. How kann I concatenate inside the WHERE clause, using postgres, considering the variable "value"  that will have its value changed ?</p>