Concat inside a WHERE clause in postgres

concatenation, postgresql

Solution

In Postgresql you concatenate using the following syntax:

(users.first_name || ' ' || users.last_name)

Reference: http://www.postgresql.org/docs/9.1/static/functions-string.html

Problem

I have a question about concat function in PostgreSQL. This sentence works well in MySQL: ``` SELECT * FROM words WHERE CONCAT (word,' ',gender,' ',semantic) LIKE '%"+value+"%'. ``` Value is a variable that is changed inside my Java program. 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 ?

Original source