Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Concat inside a WHERE clause in postgres

Tags:

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 ?